DROP VIEW

Syntax

DROP VIEW [ IF EXISTS ] view_name [ CASCADE ];

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.

This statement removes the sales_report view if it exists.

DROP VIEW IF EXISTS sales_report;

Create a non-materialized view

Show query used to create specified view

List existing views in a particular schema

⌘I