08 March 2011

How to find all trigger information in MySQL?

Select
*

From Information_Schema.Triggers
Where trigger_schema = 'YOUR_SCHEMA_NAME'
Order By event_object_table Asc, event_manipulation Asc;

No comments: