# DROP VIEW

> DROP VIEW in StackQL: remove a view or materialized view created with CREATE VIEW.

Source: https://stackql.io/language-spec/dropview

Drops a `view` or `materialized view` within a session.  

See also:  
 [[ `CREATE` ]](/language-spec/createview) [[ `REFRESH` ]](/language-spec/refreshview)

* * * 

## Syntax

*dropViewStatement::=*

   
   

```sql
DROP [ MATERIALIZED ] VIEW <viewName>;
```

* * *

## Examples

### Drop a Materialized View
```sql
DROP MATERIALIZED VIEW vw_ec2_instance_types;
```