Example: Deleting a View

If you no longer need a view, then you can delete it using SQL Developer.

In this example, you delete the HR.KING_VIEW view that you created previously in "Example: Creating a View".

To delete the HR.KING_VIEW view:

  1. In the Connections navigator in SQL Developer, navigate to the Views node in the HR schema and find the KING_VIEW, by following the instructions in "Displaying Views".
  2. Right-click the KING_VIEW, and then select Drop.

    The Drop dialog box appears.

  3. Click Apply.

    A confirmation message appears.

See Also:

"About Views"