Example: Deleting a View

If you no longer need a view, then you can delete it using Database Control.

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. Go to the Database Home page, logging in as user SYSTEM.

   See "Accessing the Database Home Page".

2. At the top of the page, click Schema to view the Schema subpage.

3. In the Database Objects section, click Views.

   The Views page appears.

4. In the Schema field, enter hr.

5. In the Object Name field, enter king.

   You can enter just the first few letters of the view name.

6. Click Go.

   KING_VIEW is displayed in the list of views.

7. Select KING_VIEW, and then click Delete.

   A Confirmation page appears.

8. Click Yes to delete the view.

   The Views page returns and displays a confirmation message.