SHOW TABLES

Lists all the base tables and views in a database.

Synopsis#

SHOW TABLES [IN database_name] ['regular_expression']

Parameters#

[IN database_name]
Specifies the database_name from which tables will be listed. If omitted, the database from the current context is assumed.
['regular_expression']
Filters the list of tables to those that match the regular_expression you specify. Only the wildcards *, which indicates any character, or |, which indicates a choice between characters, can be used.

Examples#

SHOW TABLES;

SHOW TABLES IN marketing_analytics 'orders*';