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.

SHOW SCHEMAS
[LIKE 'pattern']

Notes

Example

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