The INFORMATION_SCHEMA TRIGGERS Table This value is always  ROW . Whether the trigger activates before or after the triggering event. The value is  BEFORE  or  AFTER . This value is always  NULL . This value is always  NULL . 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 . 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. 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” . The account named in the  DEFINER  clause (often the user who created the trigger), in ’ user_name ’@’ host_name ’  format. The session value of the  character_set_client  system variable when the trigger was created. The session value of the  collation_connection  system variable when the trigger was created. 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 4834 Example • DATABASE_COLLATION • COLLATION_CONNECTION • CHARACTER_SET_CLIENT • DEFINER • SQL_MODE • CREATED • ACTION_REFERENCE_OLD_ROW  and  ACTION_REFERENCE_NEW_ROW • ACTION_REFERENCE_NEW_TABLE • ACTION_REFERENCE_OLD_TABLE • ACTION_TIMING • ACTION_ORIENTATION