DB2 Universal Database for iSeries SQL Reference

CHECK_CONSTRAINTS

The CHECK_CONSTRAINTS view contains one row for every check constraint. The following table describes the columns in the view:

Table 150. CHECK_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
CHECK_CLAUSE VARCHAR(2000)
Nullable
Text of the check constraint clause

Contains the null value if the check clause cannot be contained in the column without truncation.


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