SHOW SCHEMAS
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.
Changed in v0.5.0:
The output column is renamed from SCHEMAS to name.
Examples
SHOW DATABASES;
name
-----------
materialize
my_db
SHOW SCHEMAS FROM my_db
name
------
public