ITableDefinitionWithConstraints : ITableCreation

The ITableDefinitionWithConstraints interface exposes simple methods to create, drop, and alter tables on the data store. It also provides a mechanism to create and delete multitable and multicolumn constraints on tables.

ITableDefinitionWithConstraints extends ITableCreation by adding the ability to create and drop constraints from the base table and create base tables with constraints in one, atomic operation.

When to Implement

ITableDefinitionWithConstraints is optional for providers that do not otherwise support table creation; it is mandatory for providers that support table creation through commands and have the ability to create referential constraints (such as primary keys, foreign keys, unique, or check constraints).

Method	Description
AddConstraint	Adds a new constraint to a base table.
CreateTableWithConstraints	Creates a new base table in the data store, allowing constraints to be added atomically during table creation.
DropConstraint	Drops a constraint from a base table.
(Inherited)	All methods of ITableCreation.

This topic is a part of:

• Microsoft OLE DB