SQL Reference

SYSCAT.TRIGDEP

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

Table 95. SYSCAT.TRIGDEP Catalog View
Column Name Data Type Nullable Description
TRIGSCHEMA VARCHAR(128)
Qualified name of the trigger.
TRIGNAME VARCHAR(18)
BTYPE CHAR(1)
Type of object BNAME:

A = Alias

F = Function instance

N = Nickname

O = Privilege dependency on all subtables or subviews in a table or view hierarchy

R = Structured type

S = Summary table

T = Table

U = Typed table

V = View

W = Typed view

X = Index extension

BSCHEMA VARCHAR(128)
Qualified name of object depended on by a trigger.
BNAME VARCHAR(128)
TABAUTH SMALLINT Yes If BTYPE= O, S, T, U, V or W encodes the privileges on the table or view that are required by this trigger; otherwise null.


[ Top of Page | Previous Page | Next Page ]