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