sqlmysqldatabasetriggerssqlcommand

Show all triggers in a MySQL database


What is the command to list all triggers in a MySQL database?


Solution

  • The command for listing all triggers is:

    show triggers;
    

    or you can access the INFORMATION_SCHEMA table directly by:

    select trigger_schema, trigger_name, action_statement
    from information_schema.triggers