Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
SHOW SCHEMAS
On this page
Shows the list of schemas that exist on this SingleStore 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 Commands).
Example
SHOW SCHEMAS;
+--------------------+
| Database |
+--------------------+
| information_schema |
| memsql |
| test |
+--------------------+
3 rows in set (0.00 sec)
Last modified: June 22, 2022