Column name
|
Data type
|
Description
|
| TRIGGER_CATALOG |
VARCHAR(128) |
The name of the catalog containing the trigger. |
| TRIGGER_SCHEMA |
VARCHAR(128) |
The name of the schema containing the trigger. |
| TRIGGER_NAME |
VARCHAR(128) |
The name of the trigger. |
| EVENT
_MANIPULATION |
CHAR(20) |
The data manipulation event triggering execution of the trigger (the "trigger event").
One of:
"INSERT"
"DELETE"
"UPDATE". |
| EVENT_OBJECT
_CATALOG |
VARCHAR(128) |
The name of the catalog containing the table or view on which the trigger is created. |
| EVENT_OBJECT
_SCHEMA |
VARCHAR(128) |
The name of the schema containing the table or view on which the trigger is created. |
| EVENT_OBJECT
_TABLE |
VARCHAR(128) |
The name of the table or view on which the trigger is created. |
| ACTION_ORDER |
INTEGER |
Ordinal number for trigger execution. This number will define the execution order of triggers on the same table and with the same value for EVENT_MANIPULATION, ACTION_CONDITION, CONDITION_TIMING and ACTION_ORIENTATION. The trigger with 1 in this column will be executed first, followed by the trigger with 2 etc. |
| ACTION_CONDITION |
VARCHAR(2000) |
The character representation of the search condition in the WHEN clause of the trigger. If the length of the text exceeds 2000 characters, the NULL value will be shown. |
| ACTION
_STATEMENT |
VARCHAR(2000) |
The character representation of the body of the trigger. If the length of the text exceeds 2000 characters, the NULL value will be shown. |
| ACTION
_ORIENTATION |
CHAR(20) |
One of:
"ROW" = the trigger is a row trigger
"STATEMENT" = the trigger is a statement trigger. |
| CONDITION_TIMING |
CHAR(20) |
One of:
"BEFORE" = the trigger is executed before the triggering data manipulation operation
"INSTEAD OF" = the trigger is executed instead of the triggering data manipulation operation
"AFTER" = the trigger is executed after the triggering data manipulation operation. |
| CONDITION
_REFERENCE_OLD
_TABLE |
VARCHAR(128) |
The identifier specified in the OLD TABLE clause. |
| CONDITION
_REFERENCE_NEW
_TABLE |
VARCHAR(128) |
The identifier specified in the NEW TABLE clause. |
| CONDITION
_REFERENCE_OLD
_ROW |
VARCHAR(128) |
The identifier specified in the OLD ROW clause. |
| CONDITION
_REFERENCE_NEW
_ROW |
VARCHAR(128) |
The identifier specified in the NEW ROW clause. |
| COLUMN_LIST_IS
_IMPLICIT |
CHAR(3) |
One of:
"YES" = the trigger will be executed on update of any column in the table
"NO" = the trigger will only be executed on update of those columns specified in the UPDATE OF clause in the trigger definition. |
| CREATED |
TIMESTAMP(2) |
The date when the trigger was created. |
