Deletes a view.

Syntax

DROP VIEW [IF EXISTS] <view_name> [CASCADE]

Parameters

ParameterDescription
<view_name>The name of the view to be deleted.
CASCADEWhen specified, causes all dependent database objects such as views and aggregating indexes to be dropped also.