TRIGGERS
The system table DOMAIN.TRIGGERS
contains
all the triggers for which the current user has privileges.
|
CHAR(32) |
Name of the table schema |
|
CHAR(32) |
Name of the owner of the table |
|
CHAR(32) |
Name of the table for which the trigger was defined |
|
CHAR(32) |
Name of the trigger |
|
CHAR(3) |
Trigger is executed after an INSERT statement (YES | NO) |
|
CHAR(3) |
Trigger is executed after an UPDATE statement (YES | NO) |
|
CHAR(3) |
Trigger is executed after an DELETE statement (YES | NO) |
|
DATE |
Creation date of the trigger |
|
TIME |
Creation time of the trigger |
|
CLOB |
Trigger definition text |
|
CLOB |
Comments on the trigger |
Evaluating System Tables, TRIGGERS
SQL Reference Manual, Trigger Name (trigger_name)