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)


[ Top of Page | Previous Page | Next Page ]