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 VARGRAPHIC(2000) CCSID 1200
Nullable
Text of the check constraint clause

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