Materialize Logo

SHOW SCHEMAS

SHOW SCHEMAS returns a list of all schemas available to your Materialize instances.

Syntax

SHOW SCHEMAS FROM database_name
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