list of tables in mysql database code example

Example: list mysql tables and views

SHOW TABLES;

-- With type TABLE or VIEW
SHOW FULL TABLES;