Deleting an External Database Schema

From the External Databases Browser, the Remove command in the Databases menu enables you to remove (delete) the external database schema that is currently selected.

You cannot remove an external database schema that is currently being accessed by an ODBC driver.

When a subclass of ExternalObject is deleted, all collections and references that use the class are deleted. A message box displays a warning, prompting you to confirm that you want to delete the external object.

To remove an external database schema

  1. In the External Databases Browser, select the external database schema that you want to remove.

  2. Select the Remove command from the Databases menu.

  3. A message box is then displayed, to enable you to confirm that you want to remove the selected external database schema.

  4. Click the OK button to confirm that the selected external database schema is to be removed.

    Alternatively, click the Cancel button to abandon the deletion.

The External Databases Browser is then updated to reflect the removal of the selected external database schema. There may be a momentary delay while this updating occurs.

When you delete an external database schema, JADE performs the following actions.

  1. Deletes all ODBC catalog information that was held internally.

  2. Removes all ExternalObject and ExternalCollection subclasses defined for this external database schema.

  3. Deletes the singleton instance of the external database schema.

  4. Removes its own ExternalDatabase subclass.