CHECK_CONSTRAINTS

The CHECK_CONSTRAINTS view contains one row for every check constraint.

The following table describes the columns in the view:

Table 1. 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 Start of changeVARGRAPHIC(2000) CCSID 1200

Nullable

End of change
Text of the check constraint clause

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