首页 项目目录 关于我们
Sign In
rust
/
Materialize
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 6dd8e59864
Branches Tags
Materialize
/
doc
/
user
/
content
/
sql
/
show-materialized-views.md

show-materialized-views.md 1.2 KB
History Raw

title: "SHOW MATERIALIZED VIEWS" description: "SHOW MATERIALIZED VIEWS returns a list of materialized views being maintained in Materialize." menu: main:

parent: commands

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

Syntax

SHOW MATERIALIZED VIEWS [ FROM <schema_name> ] [ IN <cluster_name> ]

Examples

SHOW MATERIALIZED VIEWS;

     name     | cluster
--------------+----------
 winning_bids | quickstart

SHOW MATERIALIZED VIEWS LIKE '%bid%';

     name     | cluster
--------------+----------
 winning_bids | quickstart

Related pages

Option Description
FROM 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 If specified, only show materialized views from the specified cluster.