Skip to main content

table_constraints

table_constraints describes which tables have constraints.

The following fields are provided in table_constraints:

FieldDescription
CONSTRAINT_CATALOGThe name of the catalog to which the constraint belongs. This value is always def.
CONSTRAINT_SCHEMAThe name of the database to which the constraint belongs.
CONSTRAINT_NAMEThe name of the constraint.
TABLE_SCHEMAThe name of the database to which the table belongs.
TABLE_NAMEThe name of the table.
CONSTRAINT_TYPEThe type of constraint.