SYSCONSTDEP catalog table
The SYSCONSTDEP table records dependencies on check constraints or user-defined defaults for a column. The schema is SYSIBM.
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:
|
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:
|
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:
|
G |