DROP PACKAGE

Advantage SQL Engine

Removes a package and its functions from the database.

Syntax

DROP PACKAGE package_name

 

package_name ::= identifier

 

Remark

The DROP PACKAGE statement removes the specified package from the database the database. All functions owned by the package are also removed.

The user must have the DROP permission on the specified package (see GRANT).

Example

DROP PACKAGE StringFunctions;

 

See Also

ALTER FUNCTION

CREATE FUNCTION

CREATE PACKAGE

DROP FUNCTION

Effective Permissions