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

# DROP VIEW

<a id="sql-drop-view" />

Removes an existing [view](/content/sql/ddl/create-view#sql-create-view) or
[materialized view](/content/sql/ddl/create-materialized-view#sql-create-materialized-view).  All dependent
[views](/content/sql/ddl/create-view#sql-create-view),
[materialized views](/content/sql/ddl/create-materialized-view#sql-create-materialized-view),
[streams](/content/sql/ddl/create-stream#sql-create-stream), and
[SQL procedures](/content/sql/procedure#sql-procedures) will be dropped.

```sql title="DROP VIEW Syntax" theme={null}
DROP [MATERIALIZED] VIEW [IF EXISTS] [<schema name>.]<view name>
```

## Parameters

<AccordionGroup>
  <Accordion title="MATERIALIZED" id="materialized" defaultOpen>
    Optional keyword for clarity; has no impact on functionality
  </Accordion>

  <Accordion title="IF EXISTS" id="if-exists" defaultOpen>
    Optional error-suppression clause; if specified, no error will be returned if the given
    *view* does not exist
  </Accordion>

  <Accordion title="<schema name>" id="<schema-name>" defaultOpen>
    Name of the *schema* containing the *view* to remove
  </Accordion>

  <Accordion title="<view name>" id="<view-name>" defaultOpen>
    Name of the *view* to remove
  </Accordion>
</AccordionGroup>