IBM Books

Administration Guide


OBJCAT.TRIGDEP

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:

  • 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 ]