Information Schema TRIGGERS Table

Always def.

TRIGGER_SCHEMA

Database name in which the trigger occurs.

TRIGGER_NAME

Name of the trigger.

EVENT_MANIPULATION

The event that activates the trigger. Prior to MariaDB 12.0, one of INSERT, UPDATE or DELETE. From MariaDB 12.0, can contain multiple values, comma-separated.

EVENT_OBJECT_CATALOG

Always def.

EVENT_OBJECT_SCHEMA

Database name on which the trigger acts.

EVENT_OBJECT_TABLE

Table name on which the trigger acts.

ACTION_ORDER

Indicates the order that the action will be performed in (of the list of a table's triggers with identical EVENT_MANIPULATION and ACTION_TIMING values). See the clauses.

ACTION_CONDITION

NULL

ACTION_STATEMENT

Trigger body, UTF-8 encoded.

ACTION_ORIENTATION

Always ROW.

ACTION_TIMING

Whether the trigger acts BEFORE or AFTER the event that triggers it.

ACTION_REFERENCE_OLD_TABLE

Always NULL.

ACTION_REFERENCE_NEW_TABLE

Always NULL.

ACTION_REFERENCE_OLD_ROW

Always OLD.

ACTION_REFERENCE_NEW_ROW

Always NEW.

CREATED

Always NULL.

SQL_MODE

The when the trigger was created, and which it uses for execution.

DEFINER

The account that created the trigger, in the form user_name@host_name

CHARACTER_SET_CLIENT

The client when the trigger was created, from the session value of the system variable.

COLLATION_CONNECTION

The client when the trigger was created, from the session value of the system variable.

DATABASE_COLLATION

of the associated database.