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.
Shows the list of schemas that exist on this SingleStore DB instance.
SHOW SCHEMAS
[LIKE 'pattern']
pattern
- SQL LIKE clauseSHOW SCHEMAS;
+--------------------+
| Database |
+--------------------+
| information_schema |
| memsql |
| test |
+--------------------+
3 rows in set (0.00 sec)