SHOW SCHEMAS
NOTE!
For improved performance, execute this command in the
mz_introspection
cluster. To switch clusters, use SET CLUSTER = mz_introspection;
.
SHOW SCHEMAS
returns a list of all schemas available to your Materialize
instances.
Syntax
Field | Use |
---|---|
database_name | The database to show schemas from. Defaults to the current database. For available databases, see SHOW DATABASES . |
Details
Output format
SHOW SCHEMAS
’s output is a table with one column, name
.
Examples
SHOW DATABASES;
name
-----------
materialize
my_db
SHOW SCHEMAS FROM my_db
name
--------
public