SQL Reference

OBJCAT.TRIGDEP

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

Table 92. 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:

A=Alias
F=Function instance
H=Table or view hierarchy
R=Structured type
S=Summary table
T=Table
V=View

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.

Column Name	Data Type	Nullable	Description
TRIGSCHEMA	CHAR(8)		Qualified name of the trigger.
TRIGNAME	VARCHAR(18)
BTYPE	CHAR(1)		Type of object BNAME: A=Alias F=Function instance H=Table or view hierarchy R=Structured type S=Summary table T=Table V=View
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.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]