Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


TRIGGERS


The TRIGGERS system view lists the triggers owned by the current ident.

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.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX