Dropping Views

To drop a view, use either the SQL Developer navigation frame and Drop tool or the DDL statement DROP VIEW.

This tutorial shows how to use the navigation frame and Drop tool to drop the view SALES_MARKETING (changed in "Tutorial: Changing Views with the Edit View and Rename Tools"). The equivalent DDL statement is:

DROP VIEW SALES_MARKETING;

To drop the view SALES_MARKETING using the Drop tool:

1. On the Connections tab, expand hr_conn.

   Under the hr_conn icon, a list of schema object types appears.

2. Expand Views.

   A list of views appears.

3. Right-click SALES_MARKETING.

   A list of choices appears.

4. Click Drop.

   The Drop window opens.

5. Click Apply.

   The Confirmation window opens.

6. Click OK.