how to display a view in mysql code example
Example 1: mysql show views
SHOW FULL TABLES
WHERE table_type = 'VIEW';
Example 2: mysql show views
SELECT *
FROM information_schema.tables;
SHOW FULL TABLES
WHERE table_type = 'VIEW';
SELECT *
FROM information_schema.tables;