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
pattern- SQL LIKE clause- This command must be run on the master aggregator or a child aggregator node (see Node Requirements for MemSQL Commands).
Example
memsql> SHOW SCHEMAS;
+--------------------+
| Database |
+--------------------+
| information_schema |
| memsql |
| test |
+--------------------+
3 rows in set (0.00 sec)
