triggers

The triggers view provides information about triggers. For details, see Table 1. This view is read-only. All users have the read permission on this view.

**Table 1** information_schema.triggers columns
Name	Type	Description
TRIGGER_CATALOG	varchar(512)	Name of the catalog to which the view belongs. When lower_case_table_names is set to 0, the value of this column is case-sensitive. When lower_case_table_names is set to 1, the value of this column is case-insensitive.
TRIGGER_SCHEMA	varchar(64)	Name of the schema to which the trigger belongs. When lower_case_table_names is set to 0, the value of this column is case-sensitive. When lower_case_table_names is set to 1, the value of this column is case-insensitive.
TRIGGER_NAME	varchar(64)	Name of the trigger.
EVENT_MANIPULATION	varchar(6)	Trigger event. The value is INSERT (inserts a row), DELETE (deletes a row), or UPDATE (modifies a row).
EVENT_OBJECT_CATALOG	varchar(512)	Catalog where the trigger association table is located. When lower_case_table_names is set to 0, the value of this column is case-sensitive. When lower_case_table_names is set to 1, the value of this column is case-insensitive.
EVENT_OBJECT_SCHEMA	varchar(64)	Schema of the trigger association table. When lower_case_table_names is set to 0, the value of this column is case-sensitive. When lower_case_table_names is set to 1, the value of this column is case-insensitive.
EVENT_OBJECT_TABLE	varchar(64)	Name of the trigger association table. When lower_case_table_names is set to 0, the value of this column is case-sensitive. When lower_case_table_names is set to 1, the value of this column is case-insensitive.
ACTION_ORDER	bigint	Ordinal position of the event_manipulation trigger's action within the list of triggers on the same table with the same action_timing. This column is not supported in the current version, and the value is null.
ACTION_CONDITION	longtext	The value is always null.
ACTION_STATEMENT	longtext	Trigger body, that is, the statement executed when the trigger activates. This text is encoded using UTF-8.
ACTION_ORIENTATION	varchar(9)	The value is always row.
ACTION_TIMING	varchar(6)	Specifies whether the trigger activates before or after the trigger event. The value is before or after.
ACTION_REFERENCE_OLD_TABLE	varchar(64)	The value is always null.
ACTION_REFERENCE_NEW_TABLE	varchar(64)	The value is always null.
ACTION_REFERENCE_OLD_ROW	varchar(3)	Identifier of an old column. The value is always old.
ACTION_REFERENCE_NEW_ROW	varchar(3)	Identifier of a new column. The value is always new.
CREATED	datetime	Date and time when the trigger is created. This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers. This column is not supported in the current version, and the value is null.
SQL_MODE	varchar(8192)	SQL mode in effect when the trigger is created, and under which the trigger executes. This column is not supported in the current version, and the value is null.
DEFINER	varchar(93)	User who creates the trigger. This column is not supported in the current version, and the value is null.
CHARACTER_SET_CLIENT	varchar(32)	Session value of the character_set_client system variable when the trigger is created. This column is not supported in the current version, and the value is null.
COLLATION_CONNECTION	varchar(32)	Session value of the collation_connection system variable when the trigger is created. This column is not supported in the current version, and the value is null.
DATABASE_COLLATION	varchar(32)	Collation of the database with which the trigger is associated. This column is not supported in the current version, and the value is null.