To drop a view, you use the DROP VIEW statement followed by the name of the view you want to drop. For example:
DROP VIEW EmployeeDetails;
This statement would drop the EmployeeDetails view.
EmployeeDetails