Reference and syntax for the DROP VIEW command.
DROP VIEW [IF EXISTS] <view_name> [CASCADE]
<view_name>
CASCADE