SQL Reference

SYSCAT.CONSTDEP

Contains a row for every dependency of a constraint on some other object.

Table 52. SYSCAT.CONSTDEP Catalog View

Column Name	Data Type	Nullable	Description
CONSTNAME	VARCHAR(18)		Name of the constraint.
TABSCHEMA	VARCHAR(128)		Qualified name of the table to which the constraint applies.
TABNAME	VARCHAR(128)
BTYPE	CHAR(1)		Type of object that the constraint depends on. Possible values: F = Function instance I = Index instance R = Structured type
BSCHEMA	VARCHAR(128)		Qualified name of object that the constraint depends on.
BNAME	VARCHAR(18)