Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


TRIGGERS


Records triggers in the database.

Column name
Data type
Description

TRIGGER_SYSID

INTEGER

System identifier of the trigger.

EVENT_TABLE_SYSID

INTEGER

System identifier of the table on which the trigger is defined.

EVENT_MANIPULATION

CHAR(20)

One of:
"DELETE"
"INSERT"
"UPDATE".

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 text of the search condition of the trigger action WHEN clause.

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"
"STATEMENT".

CONDITION_TIMING

CHAR(20)

One of:
"BEFORE"
"AFTER"
"INSTEAD OF".

COND_REF_NEW_TABLE

VARCHAR(128)

Name of new table/row alias.

COND_REF_OLD_TABLE

VARCHAR(128)

Name of old table/row alias.

REFERENCE_NEW

CHAR(3)

One of:
"NO" = The trigger has no new table/row alias
"YES" = The trigger has new table/row alias.

REFERENCE_OLD

CHAR(3)

One of:
"NO" = The trigger has no new table/row alias
"YES" = The trigger has new table/row alias.

COLS_IS_IMPLICIT

CHAR(3)

One of:
"NO" = The trigger is invoked on update on any column (if the event is update)
"YES" = The trigger will only be invoked if a column in the for update of list is updated.

REF_SYSID

INTEGER

System identifier for foreign key constraint, if the trigger is defined for checking of a delete rule.

Primary key: TRIGGER_SYSID

Secondary index: EVENT_TABLE_SYSID



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