The syntax to permanently destroy a view is entered as follows, where
view
is the name of the view
to be destroyed:
DROP VIEW
view
The destruction of a view will have no effect on the data that the view utilizes. A view exists purely as a means
to observe data in other tables, and may be safely destroyed without losing data (though the query described by the view
will, of course, be lost). Thus any attempts to alter or delete from a view will fail.
