SYSCHECKDEP catalog table

The SYSCHECKDEP table contains one row for each reference to a column in a check constraint. The schema is SYSIBM.

Table 1. SYSIBM.SYSCHECKDEP table column descriptions
Column name Data type Description Use
TBOWNER
VARCHAR(128)
NOT NULL

The schema of the table on which the check constraint is defined.

G
TBNAME
VARCHAR(128)
NOT NULL
Name of the table on which the check constraint is defined. G
CHECKNAME
VARCHAR(128)
NOT NULL
Name of the check constraint. G
COLNAME
VARCHAR(128)
NOT NULL
Name of the column that the check constraint refers to. G
IBMREQD
CHAR(1)
NOT NULL
A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators.

The value in this field is not a reliable indicator of release dependencies.

G