The SYSCHKCST view contains one row for each check constraint in the SQL schema. The following table describes the columns in the 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 | VARGRAPHIC(2000) CCSID
1200Nullable ![]() |
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:
|
| SYSTEM_CONSTRAINT_SCHEMA | SYS_CDNAME | CHAR(10) | Name of the system schema containing the constraint. |