The system table TRIGGERS contains all the triggers for which the current user has privileges.
TRIGGERS
SCHEMANAME |
CHAR(32) |
Name of the schema of the table |
OWNER |
CHAR(32) |
Name of the owner of the table |
TABLENAME |
CHAR(32) |
Name of the table for which the trigger was defined |
TRIGGERNAME |
CHAR(32) |
Name of the trigger |
INSERT |
CHAR(3) |
Trigger is executed after an INSERT statement (YES | NO) |
UPDATE |
CHAR(3) |
Trigger is executed after an UPDATE statement (YES | NO) |
DELETE |
CHAR(3) |
Trigger is executed after an DELETE statement (YES | NO) |
CREATEDATE |
DATE(10) |
Creation date of the trigger |
CREATETIME |
TIME(8) |
Creation time of the trigger |
DEFINITION |
LONG |
Trigger definition text |
COMMENT |
LONG |
Comments on the trigger |
See also:
Evaluating System Tables, TRIGGERS
SQL Reference Manual, Trigger Name (trigger_name)