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

---

title: "SHOW CREATE MATERIALIZED VIEW" description: "SHOW CREATE MATERIALIZED VIEW returns the statement used to create the materialized view" menu: main:

parent: commands

---

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

Syntax

SHOW [REDACTED] CREATE MATERIALIZED VIEW <view_name>

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

For available materialized view names, see SHOW MATERIALIZED VIEWS.

Examples

SHOW CREATE MATERIALIZED VIEW winning_bids;

              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-md file="shared-content/sql-command-privileges/show-create-materialized-view.md"

}}

Related pages

• SHOW MATERIALIZED VIEWS
• CREATE MATERIALIZED VIEW