The system table SYSTEMTRIGGERS contains all system triggers that the current user has created.
SYSTEMTRIGGERS
SCHEMANAME |
CHAR(32) |
Name of the schema of the system trigger |
TRIGGERNAME |
CHAR(32) |
Name of the system trigger |
OWNER |
CHAR(32) |
Name of the owner of the system trigger |
CREATEDATE |
DATE(10) |
Creation date of the system trigger |
CREATETIME |
TIME(8) |
Creation time of the system trigger |
DEFINITION |
LONG |
SQL statement for creating the system trigger |
COMMENT |
LONG |
Comment for the system trigger |
See also:
SQL Reference Manual, CREATE SYSTEM TRIGGER Statement (create_system_trigger_statement)