SHOW MATERIALIZED VIEWS
SHOW MATERIALIZED VIEWS returns a list of materialized views being maintained
in Materialize.
Syntax
SHOW MATERIALIZED VIEWS [ FROM <schema_name> ] [ IN <cluster_name> ]
| Option | Description |
|---|---|
| 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
SHOW MATERIALIZED VIEWS;
name | cluster
--------------+----------
winning_bids | quickstart
SHOW MATERIALIZED VIEWS LIKE '%bid%';
name | cluster
--------------+----------
winning_bids | quickstart