FirebirdSQL logo
 EXTERNAL FUNCTIONPACKAGE BODY 

DROP PACKAGE

Drops a package header

Available in

DSQL

Syntax
DROP PACKAGE package_name
Table 1. DROP PACKAGE Statement Parameters
Parameter Description

package_name

Package name

The DROP PACKAGE statement deletes an existing package header.If a package body exists, it will be dropped together with the package header.If there are still dependencies on the package, an error will be raised.

Who Can Drop a Package

The DROP PACKAGE statement can be executed by:

  • Administrators

  • The owner of the package

  • Users with the DROP ANY PACKAGE privilege