Removing a View (DROP VIEW)

Removing a View (DROP VIEW)
A view is removed from the database with the DROP VIEW statement:
DROP VIEW ViewName [RESTRICT | CASCADE]
DROP VIEW causes the definition of the view to be deleted from the database. For
example, we could remove the Manager3Staff view using the statement:
DROP VIEW Manager3Staff;
If CASCADE is specified, DROP VIEW deletes all related dependent objects, in other
words, all objects that reference the view. This means that DROP VIEW also deletes any
views that are defined on the view being dropped. If RESTRICT is specified and there are
any other objects that depend for their existence on the continued existence of the view
being dropped, the command is rejected. The default setting is RESTRICT.