DROP VIEW
Deletes a view.
Syntax
DROP VIEW [IF EXISTS] <view_name> [CASCADE]
| Parameter | Description |
<view_name> | The name of the view to be deleted. |
CASCADE | When specified, causes all dependent database objects such as views, aggregating indexes, and join indexes, to be dropped also. |