SHOW TABLES

Lists the tables for which you have access privileges.

Syntax

SHOW [ FULL ] TABLES [ IN <schema_name> ]

Parameters

<schema_name>

Optional name of the schema to list tables from. If not specified, all tables in any schema are listed.