Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

DROP VIEW in Oracle

  1. Forget Code
  2. Oracle
  3. DROP VIEW
DROP VIEW - drops any specified view in the oracle database 

Syntax: DROP VIEW View_Name;


Example: 
DROP VIEW EMPLOYEE_VW;


Note:
- Statements referring to the view will be invalidated on a DROP VIEW statement.
- In case of any dependent views or open cursors , DROP VIEW will not be allowed.
- Dependent View must be dropped before dropping any parent objects (table).