How can I drop a view in Oracle?

Question

I have a view defined in my Oracle database and I would like to drop it. How can I drop a view?

This may answer your question: [Drop view if exists in oracle sql](https://stackoverflow.com/a/57852474) — halfer, Jun 25 '20 at 21:16
Kindly note that there is no such thing as a Question being too simple on Stack Overflow. Simple Questions are not off-topic. — Scratte, Jul 02 '20 at 22:04

score 3 · Answer 1 · answered Jun 05 '20 at 07:20

According to Oracle's documentation on DROP VIEW (Oracle Database 20c) the syntax (in the "Description of the illustration drop_view.eps") is:

DROP VIEW [ schema. ] view [ CASCADE CONSTRAINTS ] ;

..which in the simplest form, if your viewname is emp_view, will be:

DROP VIEW emp_view;

Note: This answer by Chamithra Thenuwara to "Drop view if exists in oracle sql" also shows this.

1 Answers1