table_constraints
table_constraints
describes which tables have constraints.
The following fields are provided in table_constraints
:
Field | Description |
---|---|
CONSTRAINT_CATALOG | The name of the catalog to which the constraint belongs. This value is always def . |
CONSTRAINT_SCHEMA | The name of the database to which the constraint belongs. |
CONSTRAINT_NAME | The name of the constraint. |
TABLE_SCHEMA | The name of the database to which the table belongs. |
TABLE_NAME | The name of the table. |
CONSTRAINT_TYPE | The type of constraint. |