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. |