How do you list all triggers in a MySQL Database?
What is the command to list all triggers in a MySQL database?
Answer :
The command is:
show triggers
or you can access the
INFORMATION_SCHEMA
table directly by:select trigger_schema, trigger_name, action_statement
from information_schema.triggers
- You can do this from version 5.0.10 onwards.
- More information about the
TRIGGERS
table is here.
COMMENTS