Skip to main content
Removes an existing view or materialized view. All dependent views, materialized views, streams, and SQL procedures will be dropped.
DROP VIEW Syntax

​
Parameters

MATERIALIZED

Optional keyword for clarity; has no impact on functionality

IF EXISTS

Optional error-suppression clause; if specified, no error will be returned if the given view does not exist

<schema name>

Name of the schema containing the view to remove

<view name>

Name of the view to remove