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.

Examples

SHOW DATABASES;
materialize
my_db
SHOW SCHEMAS FROM my_db
public