Dropping or removing an object

Use the Confirmation window to confirm that you want to drop or remove the objects with check marks beside them in the list.

Removing a cataloged object (such as, a database or instance) uncatalogs it.

Dropping an object deletes its contents and, if it is a cataloged object, uncatalogs it.

Any objects that are directly or indirectly dependent on an object that you drop or remove are either deleted or become inaccessible, and all references to them are invalidated. Exceptions: DB2 Universal Database for OS/390 does not delete dependent storage groups. The Data Warehouse Center does not delete objects on which other objects are dependent.

If an SQL procedure is dropped using the drop action from a procedure object, the procedure is removed only from DB2 for OS/390 Version 5 catalog table SYSIBM.SYSPROCEDURES or from DB2 Universal Database for OS/390 Version 6 catalog table SYSIBM.SYSROUTINES. The procedure source in catalog table SYSIBM.SYSPSM and procedure option information in catalog table SYSIBM.SYSPSMOPTS is not removed. To completely remove the procedure definition, including its source and options, select the Start Stored Procedure Builder action from the Procedures folder.

Fields and controls

Authorities and privileges

To drop or remove an object:

1. Select one or more objects and click Drop or Remove from the pop-up menu.
2. Optional: If you do not want to drop or remove an object that is listed in the field, clear the check box to the left of the object's name.
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 or removal. From the Show Related window, you can handle administration of other database objects.
4. To drop or remove all of the objects selected in the list, click OK. Any objects without check marks beside them are left untouched.
5. Optional: To cancel the entire operation and close the confirmation window, click Cancel.