how to show all views in mysql code example

Example 1: mysql show views

SHOW FULL TABLES 
WHERE table_type = 'VIEW';

Example 2: list mysql tables and views

SHOW TABLES;

-- With type TABLE or VIEW
SHOW FULL TABLES;