SHOW SCHEMAS
Shows the list of schemas that exist on this SingleStoreDB instance.
Syntax
SHOW SCHEMAS [LIKE 'pattern']
Remarks
pattern
- SQL LIKE clauseThis command must be run on the master aggregator or a child aggregator node (see Node Requirements for SingleStoreDB Commands).
Example
SHOW SCHEMAS; +--------------------+ | Database | +--------------------+ | information_schema | | memsql | | test | +--------------------+ 3 rows in set (0.00 sec)