Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

SHOW SCHEMAS

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

Syntax

SHOW SCHEMAS
[LIKE 'pattern']

Remarks

Example

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