Drop a database object

Once objects are no longer used, you should drop them to save system resources.

To drop an object:

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Expand the database and schema that you want to work with. Continue to expand until the object that you want to drop is visible.
  4. Right-click the object you want to drop and select Delete, or press the Delete key.
  5. On the Confirm object deletion dialog, confirm that these are the objects that you wish to delete and click Delete.

Note: Dropping an object that contains another object, such as a schema that contains a table, will result in the contained objects being dropped also. Objects that are related to the dropped objects, such as an alias for a table, will be located and you will be given the option of dropping those objects as well.

To drop a journal receiver, it must not be attached to a journal.

To drop a journal, you must stop journaling for each table that is attached to the journal.

Dropping a journal does not remove the receivers from the schema.