SHOW MATERIALIZED VIEWS
SHOW MATERIALIZED VIEWS returns a list of materialized views being maintained
in Materialize.
Syntax
| Field | Use |
|---|---|
| schema_name | The schema to show materialized views from. Defaults to first resolvable schema in the search path. For available schemas, see SHOW SCHEMAS. |
| cluster_name | The cluster to show materialized views from. If omitted, materialized views from all clusters are shown. |
Examples
SHOW MATERIALIZED VIEWS;
name | cluster
--------------+----------
winning_bids | default
SHOW MATERIALIZED VIEWS LIKE '%bid%';
name | cluster
--------------+----------
winning_bids | default