DBPedias

All your database knowledge are belong to you

DB2 zOS

SYSIBM.SYSCHECKDEP (V8)

Description: Contains one row for each reference to a column in a check constraint.

Tablespace: SYSSTR

Indexes(Fields):
DSNSDX01(TBOWNER.TBNAME.CHECKNAME COLNAME)

Column name Description Data type
TBOWNER Authorization ID of the owner of the table on which the check constraint is defined.
NOT NULL
TBNAME Name of the table on which the check constraint is defined.
NOT NULL
CHECKNAME Name of the check constraint.
NOT NULL
COLNAME Name of the column that the check constraint refers to.
NOT NULL
IBMREQD A value of Y indicates that the row came from the basic machine-readable material (MRM) tape.
NOT NULL

Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).