Removing Offline Database Objects

You can delete offline database objects from a database diagram or from the navigator by erasing them from disk.

Note: In this version of JDeveloper, you cannot delete offline tables and views from a project but have them present on your machine's disk. The reason is that the navigator is set up to show the offline tables and views that are present in a folder called database in the project's root directory. To remove offline tables and views from the navigator, they have to be deleted from this folder.

Deleting from a Database Diagram

You can delete an object from a diagram by removing it just from the diagram, or by erasing it from the disk. See Removing an Element from a Diagram.

Deleting from the Navigator

You can delete an offline table or view from the navigator by erasing it from the disk. See Permanently Deleting an Application, Project, or Other Component.

You cannot erase from disk an offline table that is referenced by a foreign key owned by another table unless the foreign key is also deleted. When you choose Erase from Disk a dialog is displayed asking you to confirm that the foreign keys should be cascade deleted.

Deleting from the Edit Table Dialog

You can delete columns from a table or constraints from an offline table. See Editing Offline Database Definitions.