Skip to content
On this page

SHOW

The SHOW keyword provides database and table information.

Examples

Show all databases:

sql
SHOW DATABASES;
sql
+---------+
| Schemas |
+---------+
| public  |
+---------+
1 row in set (0.01 sec)

Show databases by LIKE pattern:

sql
SHOW DATABASES LIKE 'p%';

Show all tables:

sql
SHOW TABLES;
sql
+---------+
| Tables  |
+---------+
| numbers |
| scripts |
+---------+
2 rows in set (0.00 sec)

Show tables in the test database:

sql
SHOW TABLES FROM test;

Show tables by like pattern:

sql
SHOW TABLES like '%prometheus%';