Dropping an object

Use the Drop window to confirm that you want to drop the object or objects selected in the box. Dropping an object deletes its contents and, if it is a cataloged object, uncatalogs it.

When you drop an object, DB2 deletes objects that are directly or indirectly dependent on the dropped object. Exception: DB2 does not delete dependent storage groups.

Authorities and privileges

To drop an object:

  1. Open the drop window.

  2. Optional: If you do not want to drop an object, clear the check box next to the object.

  3. Optional: Select an object in the table, and click the Show Related push button to open the Show Related window. This window shows the related objects that might be affected by this drop. From the Show Related window, you can handle administration of other database objects.

  4. Optional: You can click the Uncheck All or the Check All push buttons to check or clear all the check boxes in the table.

  5. Click OK in the Drop window to drop all selected objects. Only objects whose check boxes are selected in the window are dropped.

Related information