• ACTION_ORIENTATION 

This value is always ROW . 

• ACTION_TIMING 

Whether the trigger activates before or after the triggering event. The value is BEFORE  or AFTER . 

• ACTION_REFERENCE_OLD_TABLE 

This value is always NULL . 

• ACTION_REFERENCE_NEW_TABLE 

This value is always NULL . 

• ACTION_REFERENCE_OLD_ROW  and ACTION_REFERENCE_NEW_ROW 

The old and new column identifiers, respectively. The ACTION_REFERENCE_OLD_ROW  value is always OLD  and the ACTION_REFERENCE_NEW_ROW  value is always NEW . 

• CREATED 

The date and time when the trigger was created. This is a TIMESTAMP(2)  value (with a fractional part in hundredths of seconds) for triggers. 

• SQL_MODE 

The SQL mode in effect when the trigger was created, and under which the trigger executes. For the permitted values, see Section 5.1.11, “Server SQL Modes” . 

• DEFINER 

The account named in the DEFINER  clause (often the user who created the trigger), in ’ user_name ’@’ host_name ’  format. 

• CHARACTER_SET_CLIENT 

The session value of the character_set_client  system variable when the trigger was created. 

• COLLATION_CONNECTION 

The session value of the collation_connection  system variable when the trigger was created. 

## Example 

• DATABASE_COLLATION 

The collation of the database with which the trigger is associated. 

The following example uses the ins_sum  trigger defined in Section 25.3, “Using Triggers” : 

mysql> SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_SCHEMA=’test’ AND TRIGGER_NAME=’ins_sum’\G *************************** 1. row *************************** TRIGGER_CATALOG: def TRIGGER_SCHEMA: test TRIGGER_NAME: ins_sum EVENT_MANIPULATION: INSERT EVENT_OBJECT_CATALOG: def EVENT_OBJECT_SCHEMA: test 

