Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

SHOW SCHEMAS

Shows the list of schemas that exist on this SingleStore DB instance.

Syntax

SHOW SCHEMAS
[LIKE 'pattern']

Remarks

Example

SHOW SCHEMAS;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| memsql             |
| test               |
+--------------------+
3 rows in set (0.00 sec)