Share via

ITableDefinitionWithConstraints : ITableCreation

  • Article

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: