# SHOW CREATE MATERIALIZED VIEW
`SHOW CREATE MATERIALIZED VIEW` returns the statement used to create the materialized view

> For the complete documentation index, see [llms.txt](https://preview.materialize.com/materialize/40269/llms.txt).


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

## Syntax

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


| Syntax element | Description |
| --- | --- |
| <strong>REDACTED</strong> | If specified, literals will be redacted. |


For available materialized view names, see [`SHOW MATERIALIZED VIEWS`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/show-materialized-views/index.md).

## 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:

- `USAGE` privileges on the schema containing the materialized view.

## Related pages

- [`SHOW MATERIALIZED VIEWS`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/show-materialized-views/index.md)
- [`CREATE MATERIALIZED VIEW`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/create-materialized-view/index.md)