> ## Documentation Index
> Fetch the complete documentation index at: https://docs.risingwave.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SHOW CREATE MATERIALIZED VIEW

> Use the `SHOW CREATE MATERIALIZED VIEW` command to see what query was used to create the specified materialized view.

## Syntax

```bash theme={null}
SHOW CREATE MATERIALIZED VIEW mv_name;
```

## Parameters

| Parameter  | Description                                 |
| :--------- | :------------------------------------------ |
| *mv\_name* | The materialized view to show the query of. |

## Example

```sql theme={null}
CREATE MATERIALIZED VIEW v1 AS SELECT id FROM taxi_trips;
SHOW CREATE MATERIALIZED VIEW v1;
```

Here is the result.

```sql theme={null}
   Name    |                 Create Sql
-----------+---------------------------------------------
 public.v1 | CREATE MATERIALIZED VIEW v1 AS SELECT id FROM taxi_trips
(1 row)
```

## Related topics

[SHOW CREATE VIEW](/sql/commands/sql-show-create-view)

[SHOW CREATE TABLE](/sql/commands/sql-show-create-table)

<CardGroup>
  <Card title="SHOW CREATE VIEW" icon="eye" iconType="solid" href="/sql/commands/sql-show-create-view" />

  <Card title="SHOW CREATE TABLE" icon="table" iconType="solid" href="/sql/commands/sql-show-create-table" />
</CardGroup>