Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
SHOW SCHEMAS
Shows the list of schemas that exist on this SingleStore DB 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 SingleStore DB Commands).
Example
SHOW SCHEMAS;
+--------------------+
| Database |
+--------------------+
| information_schema |
| memsql |
| test |
+--------------------+
3 rows in set (0.00 sec)
