DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.CONSTDEP catalog view

Each row represents a dependency of a constraint on some other object. The constraint depends on the object of type BTYPE of name BNAME, so a change to the object affects the constraint.

Table 1. SYSCAT.CONSTDEP Catalog View
Column Name Data Type Nullable Description
CONSTNAME VARCHAR (128)   Unqualified name of the constraint.
TABSCHEMA VARCHAR (128)   Schema name of the table to which the constraint applies.
TABNAME VARCHAR (128)   Unqualified name of the table to which the constraint applies.
BTYPE CHAR (1)   Type of object on which the constraint depends. Possible values are:
  • F = Routine
  • I = Index
  • R = User-defined structured type
  • u = Module alias
BSCHEMA VARCHAR (128)   Schema name of the object on which the constraint depends.
BMODULENAME VARCHAR(128) Y Unqualified name of the module to which the object on which a dependency belongs. The null value if not a module object.
BNAME VARCHAR (128)   Unqualified name of the object on which the constraint depends.
BMODULEID INTEGER Y Identifier for the module of the object on which the constraint depends.