The TABLE_CONSTRAINTS view contains one row for each constraint. The
following table describes the columns in the view:
Table 160. TABLE_CONSTRAINTS 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'. |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.