Contains a row for every dependency of a constraint on some other
object.
Table 81. OBJCAT.CONSTDEP Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| CONSTNAME | VARCHAR(18) |
| Name of the constraint. |
| TABSCHEMA | CHAR(8) |
| Qualified name of the table to which the constraint applies. |
| TABNAME | VARCHAR(18) |
| |
| BTYPE | CHAR(1) |
| Type of object that the constraint depends on. Possible
values:
F=function instance. I=index instance. R=structured type |
| BSCHEMA | CHAR(8) |
| Qualified name of object that the constraint depends on. |
| BNAME | VARCHAR(18) |
|