List all triggers and views

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. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The reCAPTCHA verification period has expired. Please reload the page.