To
drop a view:
Click the View object in the tree. This will display all the views in the database.
Select the view you intend to drop. The view is selected.

Click the Drop button at the top of the window. The Drop View dialog box is displayed.

Note: Alternatively, right click the view to be dropped from the tree, a pop-up menu will open. Select Dropfrom the pop-up menu.
Click OK. The message clears. The remaining views in the database will be displayed.
Related topic: