DB2 Universal Database for iSeries SQL Reference

TABLE_CONSTRAINTS

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


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]