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 1. 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 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 expressed without truncation.

ROUNDING_MODE DECFLTRND CHAR(1)

Nullable

The rounding mode for the check constraint:
C
ROUND_CEILING
D
ROUND_DOWN
F
ROUND_FLOOR
G
ROUND_HALF_DOWN
E
ROUND_HALF_EVEN
H
ROUND_HALF_UP
U
ROUND_UP
SYSTEM_CONSTRAINT_SCHEMA SYS_CDNAME CHAR(10) Name of the system schema containing the constraint.