triggers

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 it is null.

ACTION_CONDITION

longtext

It 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)

It is always null.

ACTION_REFERENCE_NEW_TABLE

varchar(64)

It is always null.

ACTION_REFERENCE_OLD_ROW

varchar(3)

Identifier of an old column. It is always old.

ACTION_REFERENCE_NEW_ROW

varchar(3)

Identifier of a new column. It 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 it 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 it is null.

DEFINER

varchar(93)

User who creates the trigger. This column is not supported in the current version, and it 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 it 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 it 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 it is null.