DROP VIEW
Use the DROP VIEW command to remove an existing view from a particular schema.
Syntax
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.
DROP VIEW IF EXISTS sales_report;
Related topics
CREATE VIEW— Create a non-materialized view.SHOW CREATE VIEW— Show query used to create specified view.SHOW VIEWS— List existing views in a particular schema.