reference/sql/DROP-VIEW.html.md.erb

---
title: DROP VIEW
---

Removes a view.

## <a id="topic1__section2"></a>Synopsis

``` pre
DROP VIEW [IF EXISTS] <name. [, ...] [CASCADE | RESTRICT]
```

## <a id="topic1__section3"></a>Description

`DROP VIEW` will remove an existing view. Only the owner of a view can remove it.

## <a id="topic1__section4"></a>Parameters

<dt>IF EXISTS  </dt>
<dd>Do not throw an error if the view does not exist. A notice is issued in this case.</dd>

<dt>\<name\>  </dt>
<dd>The name (optionally schema-qualified) of the view to remove.</dd>

<dt>CASCADE  </dt>
<dd>Automatically drop objects that depend on the view (such as other views).</dd>

<dt>RESTRICT  </dt>
<dd>Refuse to drop the view if any objects depend on it. This is the default.</dd>

## <a id="topic1__section5"></a>Examples

Remove the view `topten`;

``` pre
DROP VIEW topten;
```

## <a id="topic1__section6"></a>Compatibility

`DROP VIEW` is fully conforming with the SQL standard, except that the standard only allows one view to be dropped per command. Also, the `IF           EXISTS` option is a HAWQ extension.

## <a id="topic1__section7"></a>See Also

[CREATE VIEW](CREATE-VIEW.html)