Help Center/ Data Lake Insight/ SQL Syntax Reference (To Be Offline)/ Spark SQL Syntax Reference (Unavailable Soon)/ Databases/ Viewing All Databases
Updated on 2023-11-03 GMT+08:00
View PDF

Viewing All Databases

Function

This syntax is used to query all current databases.

Syntax

1
 
SHOW [DATABASES | SCHEMAS] [LIKE regex_expression];

Keyword

None

Parameters

Table 1 Parameter description

Parameter

Description

regex_expression

Database name

Precautions

Keyword DATABASES is equivalent to SCHEMAS. You can use either of them in this statement.

Example

View all the current databases.

1
 
SHOW DATABASES;

View all databases whose names start with test.

1
 
SHOW DATABASES LIKE "test.*";
Parent topic: Databases