SHOW SCHEMAS
SHOW SCHEMAS returns a list of all schemas available in Materialize.
Syntax
SHOW SCHEMAS [ FROM <database_name> ]
| Option | Description |
|---|---|
| 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
SHOW DATABASES;
name
-----------
materialize
my_db
SHOW SCHEMAS FROM my_db
name
--------
public