Lists all the base tables and views in a database.
SHOW TABLES [IN database_name] ['regular_expression']
- [IN database_name]
- Specifies the
database_namefrom which tables will be listed. If omitted, the database from the current context is assumed.
- Filters the list of tables to those that match the
regular_expressionyou specify. Only the wildcards
*, which indicates any character, or
|, which indicates a choice between characters, can be used.
SHOW TABLES; SHOW TABLES IN marketing_analytics 'orders*';