TABLE_CONSTRAINTS

The TABLE_CONSTRAINTS view contains one row for each constraint. The following table describes the columns in the view:

Table 165. 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
  • CHECK
  • UNIQUE
  • PRIMARY KEY
  • FOREIGN KEY
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'.