DB2 Universal Database for iSeries SQL Reference

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 109. 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.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]