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 |
VARCHAR(2000) Nullable | Text of the check constraint clause
Contains the null value if the check clause cannot be expressed without truncation. |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.