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

# DROP VIEW

> Use the `DROP VIEW` command to remove an existing view from a particular schema.

## Syntax

```sql theme={null}
DROP VIEW [ IF EXISTS ] view_name [ CASCADE ];
```

## Parameters

| Parameter            | Description                                                                                                                                                                                 |
| :------------------- | :------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **IF EXISTS** clause | Do not return an error if the specified view does not exist.                                                                                                                                |
| *view\_name*         | Name of the view to be dropped.                                                                                                                                                             |
| **CASCADE** option   | If this option is specified, all objects (such as materialized views or other regular views) that depend on the view, and in turn all objects that depend on those objects will be dropped. |

## Example

This statement removes the `sales_report` view if it exists.

```sql theme={null}
DROP VIEW IF EXISTS sales_report;
```

## Related topics

<CardGroup>
  <Card title="CREATE VIEW" icon="plus" iconType="solid" href="/sql/commands/sql-create-view">
    Create a non-materialized view
  </Card>

  <Card title="SHOW CREATE VIEW" icon="eye" iconType="solid" href="/sql/commands/sql-show-create-view">
    Show query used to create specified view
  </Card>

  <Card title="SHOW VIEWS" icon="list" iconType="solid" href="/sql/commands/sql-show-views">
    List existing views in a particular schema
  </Card>
</CardGroup>