Synopsis
DROP VIEW
[schema
.]view_name
Removes a view (view_name) from the database.
Note
The view to be dropped must be in your schema, or you must have the
DROP ANY VIEW privilege to remove a view from another schema.
Example
The following example removes scott’s emploc view from the
database:
DROP VIEW scott.emploc