You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

SHOW SCHEMAS

Shows the list of schemas that exist on this MemSQL instance.

Syntax

SHOW SCHEMAS
[LIKE 'pattern']

Remarks

Example

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