SYSCHKCST

The SYSCHKCST view contains one row for each check constraint in the SQL schema. The following table describes the columns in the SYSCHKCST view.

Table 114. SYSCHKCST view
Column Name System Column Name Data Type Description
CONSTRAINT_SCHEMA DBNAME VARCHAR(128) Name of the schema containing the constraint.
CONSTRAINT_NAME RELNAME VARCHAR(128) Name of the constraint
CHECK_CLAUSE CHECK
VARCHAR(2000)
Nullable
Text of the check constraint clause

Contains the null value if the check clause cannot be expressed without truncation.