Skip to main content

SHOW DATABASES

Shows the list of databases that exist on the instance.

Syntax

SHOW DATABASES [LIKE expr | WHERE expr]

Examples

SHOW DATABASES;
+----------+
| Database |
+----------+
| default |
| for_test |
| local |
| ss |
| ss1 |
| ss2 |
| ss3 |
| system |
| test |
+----------+

Showing the databases with database "ss":

SHOW DATABASES WHERE Database = 'ss';
+----------+
| Database |
+----------+
| ss |
+----------+

Showing the databases begin with "ss":

SHOW DATABASES Like 'ss%';
+----------+
| Database |
+----------+
| ss |
| ss1 |
| ss2 |
| ss3 |
+----------+

Showing the databases begin with "ss" with where:

SHOW DATABASES WHERE Database Like 'ss%';
+----------+
| Database |
+----------+
| ss |
| ss1 |
| ss2 |
| ss3 |
+----------+

Showing the databases like substring expr:

SHOW DATABASES Like SUBSTRING('ss%' FROM 1 FOR 3);
+----------+
| Database |
+----------+
| ss |
| ss1 |
| ss2 |
| ss3 |
+----------+

Showing the databases like substring expr with where:

SHOW DATABASES WHERE Database Like SUBSTRING('ss%' FROM 1 FOR 3);
+----------+
| Database |
+----------+
| ss |
| ss1 |
| ss2 |
| ss3 |
+----------+
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today