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
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)