List all triggers and views

Share It!

Here is simple query to find list of triggers on chosen database

Example:  SHOW TRIGGERS;

If you want like to find list of views for particular database, then here you can go with.

Syntax: SHOW FULL TABLES IN {DATABASE_NAME} WHERE TABLE_TYPE LIKE ‘VIEW’;

Example: SHOW FULL TABLES IN mydatabase WHERE TABLE_TYPE LIKE ‘VIEW’;

Leave a Reply

Your email address will not be published.