show views in a database code example

Example 1: mysql show views

SHOW FULL TABLES 
WHERE table_type = 'VIEW';

Example 2: mysql show views

SELECT * 
FROM information_schema.tables;