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. |