list mysql tables and views code example Example: list mysql tables and views SHOW TABLES; -- With type TABLE or VIEW SHOW FULL TABLES;