2.5 Dropping a Package

Other Resources

Download Postgres
Free Postgres Training
Webinar: Exploring 10 Postgres Tips and Tricks

Postgres as a Service

Deploy a Managed Postgres Cluster in Minutes! Enterprise-ready and Oracle compatible.

Try it Now Free

2 Packages : 2.5 Dropping a Package

2.5 Dropping a Package

The syntax for deleting an entire package or just the package body is as follows:

DROP PACKAGE [ BODY ] package_name;

If the keyword, BODY, is omitted, both the package specification and the package body are deleted - i.e., the entire package is dropped. If the keyword, BODY, is specified, then only the package body is dropped. The package specification remains intact. package_name is the identifier of the package to be dropped.

Following statement will destroy only the package body of emp_admin:

DROP PACKAGE BODY emp_admin;

The following statement will drop the entire emp_admin package:

DROP PACKAGE emp_admin;

2 Packages : 2.5 Dropping a Package