SQL Reference

SYSCAT.TRIGGERS

Contains one row for each trigger. For table hierarchies, each trigger is recorded only at the level of the hierarchy where it was created.

Table 96. SYSCAT.TRIGGERS Catalog View
Column Name Data Type Nullable Description
TRIGSCHEMA VARCHAR(128)
Qualified name of the trigger.
TRIGNAME VARCHAR(18)
DEFINER VARCHAR(128)
Authorization ID under which the trigger was defined.
TABSCHEMA VARCHAR(128)
Qualified name of the table to which this trigger applies.
TABNAME VARCHAR(128)
TRIGTIME CHAR(1)
Time when triggered actions are applied to the base table, relative to the event that fired the trigger:

A = Trigger applied after event

B = Trigger applied before event

TRIGEVENT CHAR(1)
Event that fires the trigger.

I = Insert

D = Delete

U = Update

GRANULARITY CHAR(1)
Trigger is executed once per:

S = Statement

R = Row

VALID CHAR(1)

Y = Trigger is valid

X = Trigger is inoperative; must be re-created.


CREATE_TIME TIMESTAMP
Time at which the trigger was defined. Used in resolving functions and types.
QUALIFIER VARCHAR(128)
Contains value of the default schema at the time of object definition.
FUNC_PATH VARCHAR(254)
Function path at the time the trigger was defined. Used in resolving functions and types.
TEXT CLOB(64K)
The full text of the CREATE TRIGGER statement, exactly as typed.
REMARKS VARCHAR(254) Yes User-supplied comment, or null.


[ Top of Page | Previous Page | Next Page ]