How To Drop an Existing View

Q

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

✍: FYIcenter.com

A

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💬