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

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

## Syntax

```sql theme={null}
SHOW CREATE VIEW view_name;
```

## Parameters

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

## Example

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

Here is the result.

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

## Related topics

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

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