ContextQMD
Back to Materialize

SHOW CREATE MATERIALIZED VIEW

doc/user/content/sql/show-create-materialized-view.md

1231.4 KB
Original Source

SHOW CREATE MATERIALIZED VIEW returns the DDL statement used to create the materialized view.

Syntax

sql
SHOW [REDACTED] CREATE MATERIALIZED VIEW <view_name>;

{{< yaml-table data="show_create_redacted_option" >}}

For available materialized view names, see SHOW MATERIALIZED VIEWS.

Examples

mzsql
SHOW CREATE MATERIALIZED VIEW winning_bids;
nofmt
              name               |                                                                                                                       create_sql
---------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 materialize.public.winning_bids | CREATE MATERIALIZED VIEW "materialize"."public"."winning_bids" IN CLUSTER "quickstart" AS SELECT * FROM "materialize"."public"."highest_bid_per_auction" WHERE "end_time" < "mz_catalog"."mz_now"()

Privileges

The privileges required to execute this statement are:

{{% include-headless "/headless/sql-command-privileges/show-create-materialized-view" %}}