Deleting database objects

 

After you create database objects on your system, you might want to delete them to save system resources. You need delete authority to perform these tasks.

To keep the information in these tables, create a third schema and copy the tables and views to it.

1. To delete the INVENTORY_LIST table from the LIBRARY1 schema, follow these steps:

   1. From iSeries™ Navigator, expand the system that you want to use.

   2. Expand Databases and the database that you want to work with.

   3. Expand Schemas and select LIBRARY1.

   4. Select Tables.

   5. Right-click INVENTORY_LIST and select Delete or press the Delete key.

   6. In the Object Deletion Confirmation window, select Delete. The INVENTORY_LIST table is deleted.

2. To delete the SUPPLIERS table from LIBRARY1 and delete LIBRARY1, follow these steps:

   1. Right-click SUPPLIERS and select Delete or press the Delete key.

   2. In the Object Deletion Confirmation window, select Yes. A new window opens, indicating that the view LOWER_COST is dependent on SUPPLIERS. The view should also be deleted.

   3. Click Delete. SUPPLIERS and LOWER_COST are deleted, and LIBRARY1 is empty.

   4. Right-click LIBRARY1 and select Delete.

   5. In the Object Deletion Confirmation window, select Yes. LIBRARY1 is deleted.

3. To delete the SAMPLELIB schema, follow these steps:

   1. Navigate to SAMPLELIB in the Schemas menu.

   2. Right-click SAMPLELIB and select Delete.

   3. In the Object Deletion Confirmation window, select Delete. A new window opens, indicating that SAMPLELIB contains the INVENTORY_LIST table and the RECENT_ORDERS view and that RECENT_ORDERS is dependent on INVENTORY_LIST.

   4. Click Yes to delete SAMPLELIB, INVENTORY_LIST, and RECENT_ORDERS.

 

Parent topic:

Getting started with iSeries Navigator