list mysql tables and views
snippet in sql

list mysql tables and views

user5679

SHOW TABLES;

-- With type TABLE or VIEW
SHOW FULL TABLES;