Contains a row for every dependency of a trigger on some other
object.
Table 116. OBJCAT.TRIGDEP Catalog View
Column Name | Data Type | Nullable | Description |
---|---|---|---|
TRIGSCHEMA | CHAR(8) |
| Qualified name of the trigger. |
TRIGNAME | VARCHAR(18) |
| |
BTYPE | CHAR(1) |
| Type of object BNAME:
|
BSCHEMA | CHAR(8) |
| Qualified name of object depended on by a trigger. |
BNAME | VARCHAR(18) |
| |
TABAUTH | SMALLINT | Yes | If BTYPE=T or V, encodes the privileges on the table or view that are required by this trigger; otherwise null. |