The TABLE_CONSTRAINTS view contains one row for each constraint.
The following table describes the columns in the view:
| Column Name | Data Type | Description |
|---|---|---|
| CONSTRAINT_CATALOG | VARCHAR(128) | Relational database name |
| CONSTRAINT_SCHEMA | VARCHAR(128) | Name of the schema containing the constraint. |
| CONSTRAINT_NAME | VARCHAR(128) | Name of the constraint. |
| TABLE_CATALOG | VARCHAR(128) | Relational database name |
| TABLE_SCHEMA | VARCHAR(128) | Name of the schema containing the table. |
| TABLE_NAME | VARCHAR(128) | Name of the table which the constraint is created over. |
| CONSTRAINT_TYPE | VARCHAR(11) | Constraint Type
|
| IS_DEFERRABLE | VARCHAR(3) | Indicates whether the constraint checking can be deferred. Contains 'NO'. |
| INITIALLY_DEFERRED | VARCHAR(3) | Indicates whether the constraint was defined as initially deferred. Contains 'NO'. |