Postgres Plus Advanced Server Oracle Compatibility Developer's Guide :
DROP VIEW -- remove a view
DROP VIEW name
DROP VIEW drops an existing view. To execute this command you must be the owner of the view. The named view will not be deleted if other objects are dependent upon this view (such as a view of a view).
The name (optionally schema-qualified) of the view to remove.
This command will remove the view called dept_30:
DROP VIEW dept_30;