ContextQMD
Back to Materialize

SHOW SCHEMAS

doc/user/content/sql/show-schemas.md

123769 B
Original Source

SHOW SCHEMAS returns a list of all schemas available in Materialize.

Syntax

mzsql
SHOW SCHEMAS [ FROM <database_name> ];
Syntax elementDescription
FROM <database_name>If specified, only show schemas from the specified database. 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

mzsql
SHOW DATABASES;
nofmt
   name
-----------
materialize
my_db
mzsql
SHOW SCHEMAS FROM my_db
nofmt
  name
--------
 public