How To Drop an Existing View


How To Drop an Existing View? - Oracle DBA FAQ - Understanding SQL DDL Statements



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.

2007-04-22, 4344👍, 0💬