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

DROP PACKAGE (U-SQL)

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.

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

Semantics of Syntax Elements

  • IF EXISTS
    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.

Examples

© 2018 Microsoft