Outdated Version

You are viewing an older version of this section. View current production version.

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)