" Live as if you were to die tomorrow. Learn as if you were to live forever.. "
- Mahatma Gandhi
" Live as if you were to die tomorrow. Learn as if you were to live forever.. "
- Mahatma Gandhi
|
While MySQL has features like StoredProcedure and View, it doesn’t have any option for displaying TRIGGER list in the ‘Schemata’ tab (right) section of QueryBrowser.
Generally, we need a third party control like MySQL Workbench to get the list of existing TRIGGER lists.But there is another way through which we can get existing trigger lists and that is from the Metadata(Data about data).
|
|
To get all the trigger list irrespective of the database name:
SELECT * FROM information_schema.TRIGGERS;
To get list of trigger against a specific database:
SELECT * FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA=’database_name’;
|