SQL Reference

SYSCAT.TRIGDEP

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

Table 91. 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.

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 | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]