ContextQMD
Back to Materialize

SHOW MATERIALIZED VIEWS

doc/user/content/sql/show-materialized-views.md

1231.0 KB
Original Source

SHOW MATERIALIZED VIEWS returns a list of materialized views being maintained in Materialize.

Syntax

mzsql
SHOW MATERIALIZED VIEWS [ FROM <schema_name> ] [ IN <cluster_name> ];
Syntax elementDescription
FROM <schema_name>If specified, only show materialized views from the specified schema. Defaults to first resolvable schema in the search path. For available schemas, see SHOW SCHEMAS.
IN <cluster_name>If specified, only show materialized views from the specified cluster.

Examples

mzsql
SHOW MATERIALIZED VIEWS;
nofmt
     name     | cluster
--------------+----------
 winning_bids | quickstart
mzsql
SHOW MATERIALIZED VIEWS LIKE '%bid%';
nofmt
     name     | cluster
--------------+----------
 winning_bids | quickstart