How to find all views in a MySQL database

We can use the following MySQL query to list out all views created in a specific database.

>SHOW FULL TABLES IN DB WHERE TABLE_TYPE LIKE 'VIEW';

Where DB need to be replaced with the name of the database.

That's all…