TRIGGERED_UPDATE

www.mimer.com/developer

TRIGGERED_UPDATE_COLUMNS

The TRIGGERED_UPDATE_COLUMNS system view lists the columns owned by the current ident that are referenced from the explicit column list in the trigger event of an UPDATE trigger.

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_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 UPDATE trigger is created.

EVENT_OBJECT
_TABLE

VARCHAR(128)

The name of the table or view on which the UPDATE trigger is created.

EVENT_OBJECT
_COLUMN

VARCHAR(128)

The name of the table or view column referenced in the column list of the UPDATE trigger event.

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_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 UPDATE trigger is created.
EVENT_OBJECT _TABLE	VARCHAR(128)	The name of the table or view on which the UPDATE trigger is created.
EVENT_OBJECT _COLUMN	VARCHAR(128)	The name of the table or view column referenced in the column list of the UPDATE trigger event.

Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se