Show Tables

SHOW TABLES [{FROM|IN} db_name] [LIKE 'pattern']

Return all tables. Shows a table’s database and whether a table is temporary.

FROM | IN
Return all tables in a database.
LIKE 'pattern'
Indicates which table names to match. In pattern, * matches any number of characters.