Drop views

The DROP VIEW command drops (or removes) a view.

You must be the owner of the view or have been granted the Drop privilege on views to drop an existing view from the database.

To drop a view, enter:
   MYDB.SCHEMA(USER)=> DROP VIEW emp;