Contains one row for each trigger.
Table 117. OBJCAT.TRIGGERS Catalog View
|Column Name||Data Type||Nullable||Description|
||Qualified name of the trigger.|
||Authorization ID under which the trigger was defined.|
||Qualified name of the table to which this trigger applies.|
||Time when triggered actions are applied to the base table, relative to
the event that fired the trigger:
B=Trigger applied before event A=Trigger applied after event
||Event that fires the trigger.
I=Insert D=Delete U=Update
||Trigger is executed once per:
Y=Trigger is valid X=Trigger is inoperative; must be re-created.
||The full text of the CREATE TRIGGER statement, exactly as typed.|
||Time at which the trigger was defined. Used in resolving functions and types.|
||Function path at the time the trigger was defined. Used in resolving functions and types.|
||Qualified name of the table where the trigger was introduced.|
|REMARKS||VARCHAR(254)||Yes||User-supplied comment, or null.|
[ DB2 List of Books | Search the DB2 Books ]