The CHECK_CONSTRAINTS view contains one row for every check constraint. The following table describes the columns in the view:
Column Name | Data Type | Description |
---|---|---|
CONSTRAINT_CATALOG | VARCHAR(128) | Relational database name |
CONSTRAINT_SCHEMA | VARCHAR(128) | Name of the schema containing the constraint |
CONSTRAINT_NAME | VARCHAR(128) | Name of the constraint |
CHECK_CLAUSE | VARCHAR(2000)
Nullable |
Text of the check constraint clause
Contains the null value if the check clause cannot be contained in the column without truncation. |
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.