How to get a list of MySQL views? November 16, 2022 by Tarik SHOW FULL TABLES IN database_name WHERE TABLE_TYPE LIKE 'VIEW'; MySQL query to find all views in a database