DB2 Version 10.1 for Linux, UNIX, and Windows

Dropping packages (PL/SQL)

You can drop a package if it is no longer needed. Alternatively, if you want to reuse the package, you have the option to drop only the package body.

Syntax


>>-DROP--PACKAGE--+------+--package-name-----------------------><
                  '-BODY-'

BODY: Specifies that only the package body is to be dropped. If this keyword is omitted, both the package specification and the package body are dropped.
package-name: Specifies the name of a package.

The following example shows how to drop only the body of a package named EMP_ADMIN:

DROP PACKAGE BODY emp_admin

The following example shows how to drop both the specification and the body of the package:

DROP PACKAGE emp_admin