INFORMATION_SCHEMA.TRIGGERS

Displays all triggers defined on the tables and views in the current database. Only the triggers owned by the current user or those on which the current user has permissions other than SELECT are displayed, as shown in Table 1.

**Table 1** INFORMATION_SCHEMA.TRIGGERS columns
Name	Type	Description
trigger_catalog	information_schema.sql_identifier	Name of the database that contains the trigger.
trigger_schema	information_schema.sql_identifier	Name of the schema that contains the trigger.
trigger_name	information_schema.sql_identifier	Trigger name.
event_manipulation	information_schema.character_data	Type of the event that triggers the trigger. The value can be INSERT, UPDATE, or DELETE.
event_object_catalog	information_schema.sql_identifier	Name of the database that contains the table where the trigger is located.
event_object_schema	information_schema.sql_identifier	Name of the schema that contains the table where the trigger is located.
event_object_table	information_schema.sql_identifier	Name of the table where the trigger is located.
action_order	information_schema.cardinal_number	Trigger sequence of triggers with the same event_manipulation, action_timing and action_orientation in the same table.
action_condition	information_schema.character_data	WHEN condition of a trigger. By default, this column is left blank.
action_statement	information_schema.character_data	Statement executed by the trigger.
action_orientation	information_schema.character_data	Specifies whether the trigger fires once for each row being processed or once for each statement.
action_timing	information_schema.character_data	Time when a trigger is triggered. The value can be BEFORE, AFTER, or INSTEAD OF.
action_reference_old_table	information_schema.sql_identifier	This parameter is meaningless and is left blank.
action_reference_new_table	information_schema.sql_identifier	This parameter is meaningless and is left blank.
action_reference_old_row	information_schema.sql_identifier	This parameter is meaningless and is left blank.
action_reference_new_row	information_schema.sql_identifier	This parameter is meaningless and is left blank.
created	information_schema.time_stamp	This parameter is meaningless and is left blank.