ContextQMD
Back to Materialize

SHOW CREATE VIEW

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

123909 B
Original Source

SHOW CREATE VIEW returns the SELECT statement used to create the view.

Syntax

sql
SHOW [REDACTED] CREATE VIEW <view_name>;

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

For available view names, see SHOW VIEWS.

Examples

mzsql
SHOW CREATE VIEW my_view;
nofmt
            name            |                                            create_sql
----------------------------+--------------------------------------------------------------------------------------------------
 materialize.public.my_view | CREATE VIEW "materialize"."public"."my_view" AS SELECT * FROM "materialize"."public"."my_source"

Privileges

The privileges required to execute this statement are:

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