DROP PACKAGE v17

Name

DROP PACKAGE Remove a package.

Synopsis

DROP PACKAGE [ BODY ] <name>

Description

DROP PACKAGE drops an existing package. To execute this command, you must be a superuser or the owner of the package. Specify BODY to remove only the package body without dropping the package specification. Omit BODY to remove both the package specification and body.

Parameters

name

The name (optionally schema-qualified) of a package to remove.

Examples

This example removes the emp_admin package:

DROP PACKAGE emp_admin;

See also

CREATE PACKAGE, CREATE PACKAGE BODY