List triggers by table name in MySQL database

Article for: IBM Db2 Teradata MariaDB

Query below lists tables with their triggers.


select event_object_schema as database_name,
       event_object_table as table_name,
       event_manipulation as trigger_event,
       action_statement as 'definition'
from information_schema.triggers 
where trigger_schema not in ('sys','mysql')
order by database_name,


  • database_name - name of the table database name
  • table_name - name of the table
  • trigger_name - name of the trigger
  • action_order - the ordinal position of the trigger's action within the list of triggers on the same table with the same trigger_event and action_timing
  • action_timing - trigger activation time:
    • before
    • after
  • trigger_event - specific SQL operation:
    • insert
    • update
    • delete
  • definition - SQL definiton of trigger


  • One row represents one trigger
  • Scope of rows: all table triggers in a database
  • Ordered by database and table name

Sample results

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.