If you have an existing view, and you don't want it anymore, you can delete it by using the DROP VIEW statement as shown in the following script:

DROP VIEW employee_department;

View dropped.