# DROP VIEW

> StackQL 中的 DROP VIEW：移除以 CREATE VIEW 建立的檢視或具體化檢視。

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

在工作階段中卸除 `view` 或 `materialized view`。  

另請參閱：  
 [[ `CREATE` ]](/language-spec/createview) [[ `REFRESH` ]](/language-spec/refreshview)

* * * 

## 語法

*dropViewStatement::=*

&nbsp;  
&nbsp;  

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

* * *

## 範例

### 卸除具體化檢視
```sql
DROP MATERIALIZED VIEW vw_ec2_instance_types;
```
