triggers

triggers provides information about triggers.

The following fields are provided in triggers:

FieldDescription
TRIGGER_CATALOGThe name of the catalog to which the trigger belongs. This value is always def.
TRIGGER_SCHEMAThe name of the database to which the trigger belongs.
TRIGGER_NAMEThe name of the trigger.
EVENT_MANIPULATIONThe trigger event. This is the type of operation on the associated table for which the trigger activates. The value is INSERT (a row was inserted), DELETE (a row was deleted), or UPDATE (a row was modified).
EVENT_OBJECT_CATALOGEvery trigger is associated with exactly one table. The catalog in which this table occurs.
EVENT_OBJECT_SCHEMAEvery trigger is associated with exactly one table. The database in which this table occurs.
EVENT_OBJECT_TABLEThe name of the table that the trigger is associated with.
ACTION_ORDERThe ordinal position of the trigger's action within the list of triggers on the same table with the same EVENT_MANIPULATION and ACTION_TIMING values.
ACTION_CONDITIONThis value is always NULL.
ACTION_STATEMENTThe trigger body; that is, the statement executed when the trigger activates. This text uses UTF-8 encoding.
ACTION_ORIENTATIONThis value is always ROW.
ACTION_TIMINGWhether the trigger activates before or after the triggering event. The value is BEFORE or AFTER.
ACTION_REFERENCE_OLD_TABLEThis value is always NULL.
ACTION_REFERENCE_NEW_TABLEThis value is always NULL.
ACTION_REFERENCE_OLD_ROWThe old column identifiers. The value is always OLD.
ACTION_REFERENCE_NEW_ROWThe new column identifiers. The value is always NEW.
CREATEDThe date and time when the trigger was created. This is a DATETIME(2) value (with a fractional part in hundredths of seconds) for triggers.
SQL_MODEThe SQL mode in effect when the trigger was created, and under which the trigger executes.
DEFINERThe user named in the DEFINER clause (often the user who created the trigger).
CHARACTER_SET_CLIENT
COLLATION_CONNECTION
DATABASE_COLLATIONThe collation of the database with which the trigger is associated.
In this article
Copyright © 2024 CelerData