Link Search Menu Expand Document

DROP VIEW

Deletes a view.

Syntax

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

Parameters

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