SHOW DATABASES
NOTE!
For improved performance, execute this command in the
mz_introspection
cluster. To switch clusters, use SET CLUSTER = mz_introspection;
.
SHOW DATABASES
returns a list of all databases available to your Materialize
instances.
Syntax
Details
Output format
SHOW DATABASES
’s output is a table with one column, name
.
Examples
CREATE DATABASE my_db;
SHOW DATABASES;
materialize
my_db