Skip to main content

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

ParameterDescription
IF EXISTS clauseDo not return an error if the specified view does not exist.
view_nameName of the view to be dropped.
CASCADE optionIf 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;

Help us make this doc better!