Viewing All Databases

Function

This syntax is used to query all current databases.

Syntax

1

SHOW [DATABASES | SCHEMAS] [LIKE regex_expression];

Keywords

None

Parameters

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.*";