Table of contents
Collapse the table of content
Expand the table of content


Michael Rys|Last Updated: 5/15/2018
4 Contributors

The DROP PACKAGE statement drops packages. As in the case with other meta data objects, a package gets dropped even if another package, table-valued function or procedure depends on it.

Drop_Package_Statement :=                                                                                
    'DROP' 'PACKAGE' ['IF' 'EXISTS'] Identifier.

Semantics of Syntax Elements

    If a package of the given name does not exist, or the user has no permissions to drop the package, an error is raised. If the optional IF EXISTS is specified, then the statement drops the package if it already exists, or succeeds without changes if the package does not exist or the user has no permission to at least enumerate all existing packages.

  • Identifier
    Specifies the name of the package to be dropped. If the package name is a fully-specified three-part name, the package in the specified database and schema will be dropped. If the name is a two-part name, the package will be dropped in the current database context and specified schema. If the name is a simple identifier, then the package will be dropped in the current database and schema context.


© 2018 Microsoft