CODE EXAMPLE FOR SQL

list mysql tables and views

SHOW TABLES;

-- With type TABLE or VIEW
SHOW FULL TABLES;