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.