TRIGGERS
This
system table contains all the triggers for which the current user has privileges.TRIGGERS
|
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) |
Trigger name |
|
INSERT |
CHAR(3) |
Trigger type |
|
UPDATE |
CHAR(3) |
Trigger type |
|
DELETE |
CHAR(3) |
Trigger type |
|
CREATEDATE |
DATE |
Creation date of the trigger |
|
CREATETIME |
TIME |
Creation time of the trigger |
|
DEFINITION |
LONG |
Trigger definition text |
|
COMMENT |
LONG |
Comment on the trigger |