Dropping Schema Objects

You can drop these objects from the Connection Navigator directly:

• Functions and procedures
• Object types
• Views, materialized views, and materialized view logs
• Packages and package bodies
• Sequences
• Synonyms
• Tables
• Triggers

To drop one of the listed objects from a schema:

1. Select View | Connection Navigator .
2. In Connection Navigator, expand Database and select a database connection and expand it.
3. In the connection, select a schema and expand it.
4. In the schema, select a folder with the same name as the object type (for example, Table or View).
5. In the folder, right-click the object and choose Drop.
6. In the Drop Confirmation dialog click Yes to delete the object, or No to leave the schema unchanged.

• Select an object in the Connection Navigator and click the red X (Delete) button in the toolbar.
• Select an object and choose Edit | Delete.
• The SQL worksheet can also be used to drop objects. It is the only method for dropping users.
• The Oracle Database command-line utility dropjava can also be used to drop Java sources, binaries, and resources from a schema.

Related topics

Creating, Editing, and Dropping Schema Objects
Removing Offline Database Objects

Copyright © 1997, 2004, Oracle. All rights reserved.