Skip to main content

SHOW TABLES

Shows a list of tables in the currently selected database.

Syntax​

SHOW [EXTENDED] [FULL] TABLES
    [{FROM | IN} db_name]
    [HISTORY]
    [LIKE 'pattern' | WHERE expr]

Examples​

SHOW TABLES;
+------------------+
| Tables_in_system |
+------------------+
| clusters         |
| columns          |
| configs          |
| contributors     |
| credits          |
| databases        |
| engines          |
| functions        |
| metrics          |
| one              |
| processes        |
| query_log        |
| roles            |
| settings         |
| tables           |
| tracing          |
| users            |
| warehouses       |
+------------------+

Showing the tables with table name "settings":

SHOW TABLES LIKE 'settings';
+------------------+
| Tables_in_system |
+------------------+
| settings         |
+------------------+

Showing the tables named as "t4", including the dropped ones that are still within their retention periods: 

DROP TABLE t4;
SHOW TABLES HISTORY LIKE 't4';
+-------------------+-------------------------------+
| Tables_in_default | drop_time                     |
+-------------------+-------------------------------+
| t4                | 2022-05-25 05:56:49.622 +0000 |
+-------------------+-------------------------------+

Showing the tables begin with "co":

SHOW TABLES LIKE 'co%';
+------------------+
| Tables_in_system |
+------------------+
| columns          |
| configs          |
| contributors     |
+------------------+

Showing the tables begin with "co" with WHERE:

SHOW TABLES WHERE name LIKE 'co%';
+------------------+
| Tables_in_system |
+------------------+
| columns          |
| configs          |
| contributors     |
+------------------+

Showing the tables are inside "system":

SHOW TABLES FROM 'system';
+------------------+
| Tables_in_system |
+------------------+
| clusters         |
| columns          |
| configs          |
| contributors     |
| credits          |
| databases        |
| engines          |
| functions        |
| metrics          |
| one              |
| processes        |
| query_log        |
| roles            |
| settings         |
| tables           |
| tracing          |
| users            |
| warehouses       |
+------------------+