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