MDAC 2.5 SDK - OLE DB Programmer's Reference
OLE DB Interfaces


 

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
CreateTableWithConstraints Creates a new base table in the data store, allowing constraints to be added atomically during table creation.
AddConstraint Adds a new constraint to a base table.
DropConstraint Drops a constraint from a base table.