SYSCONSTDEP catalog table

The SYSCONSTDEP table records dependencies on check constraints or user-defined defaults for a column. The schema is SYSIBM.

Table 1. SYSIBM.SYSCONSTDEP table column descriptions
Column name Data type Description Use
BNAME
VARCHAR(128)
NOT NULL
 Name of the object on which the dependency exists. G
BSCHEMA
VARCHAR(128)
NOT NULL
 Schema of the object on which the dependency exists. G
BTYPE
CHAR(1)
NOT NULL
 Type of object on which the dependency exists:
F
Function instance
 G
DTBNAME
VARCHAR(128)
NOT NULL
 Name of the table to which the dependency applies. G
DTBCREATOR
VARCHAR(128)
NOT NULL

The schema of the table to which the dependency applies.

 G
DCONSTNAME
VARCHAR(128)
NOT NULL
 If DTYPE = 'C', the unqualified name of the check constraint. If DTYPE = 'D', a column name. G
DTYPE
CHAR(1)
NOT NULL
 Type of object:
C
Check constraint
D
User-defined default constant
 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
DTBOWNER
VARCHAR(128)
NOT NULL WITH
DEFAULT
 Authorization ID of the owner of the table or a zero length string for tables that were created in a Db2 release prior to Version 9. G
OWNERTYPE
CHAR(1)
NOT NULL WITH
DEFAULT
 Indicates the type of owner:
blank
Authorization ID
R
Role
 G