SYSCAT.TRIGDEP catalog view

Each row represents a dependency of a trigger on some other object. The trigger depends on the object of type BTYPE of name BNAME, so a change to the object affects the trigger.

Table 1. SYSCAT.TRIGDEP Catalog View
Column Name	Data Type	Nullable	Description
TRIGSCHEMA	VARCHAR (128)		Schema name of the trigger.
TRIGNAME	VARCHAR (128)		Unqualified name of the trigger.
BTYPE	CHAR (1)		Type of object on which there is a dependency. Possible values are: A = Table alias B = Trigger C = Column F = Routine G = Global temporary table H = Hierachy table I = Index K = Package L = Detached table N = Nickname O = Privilege dependency on all subtables or subviews in a table or view hierarchy Q = Sequence R = User-defined data type S = Materialized query table T = Table (not typed) U = Typed table V = View (not typed) W = Typed view X = Index extension Z = XSR object m = Module q = Sequence alias u = Module alias v = Global variable * = Anchored to the row of a base table
BSCHEMA	VARCHAR (128)		Schema name of the object on which there is a dependency.
BMODULENAME	VARCHAR (128)	Y	Unqualified name of the module to which the object on which a dependency belongs. The null value if not a module object.
BNAME	VARCHAR (128)		Unqualified name of the object on which there is a dependency. For routines (BTYPE = 'F'), this is the specific name.
BMODULEID	INTEGER	Y	Identifier for the module of the object on which there is a dependency.
TABAUTH	SMALLINT	Y	The value for this column is encoded as a bitmap, the values of which can be found in `<install path>/include/sql.h` and are as follows: 0x1 = Control Authority 0x2 = Alter Privilege 0x4 = Alter Privilege 0x8 = Index Privilege 0x10 = Insert Privilege 0x20 = Select Privilege 0x40 = Update Privilege 0x80 = Reference Privilege 0x2000 = Key Dependency 0x4000 = Cascade Dependency If BTYPE = 'O', 'S', 'T', 'U', 'V', 'W', or 'v', encodes the privileges on the table or view that are required by a dependent trigger; null value otherwise.