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, 2006. All Rights Reserved.