SHOW TABLES

Shows the list of tables in the currently selected database.

Description

Shows the list of tables in the currently selected database.

Syntax

> SHOW TABLES  [LIKE 'pattern' | WHERE expr | FROM db_name | IN db_name]

Examples

> SHOW TABLES;
+---------------------+
| Tables_in_database  |
+---------------------+
| clusters            |
| contributors        |
| databases           |
| functions           |
| numbers             |
| numbers_local       |
| numbers_mt          |
| one                 |
| processes           |
| settings            |
| tables              |
| tracing             |
+---------------------+