Writing code should include the DROP VIEW command, the name of the view, and reflect the following syntax:

DROP VIEW nameOfview;

Note that a view created with the CREATE OR REPLACE option will automatically drop the old view of the same name and replace it with the new code. A view can be completely eradicated with the code above.