DROP PACKAGE (U-SQL)
Drop_Package_Statement := 'DROP' 'PACKAGE' ['IF' 'EXISTS'] Identifier.
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 EXISTSis 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.
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.
The examples can be executed in Visual Studio with the Azure Data Lake Tools plug-in.
The scripts can be executed locally. An Azure subscription and Azure Data Lake Analytics account is not needed when executed locally.
The examples utilize the packages created from CREATE PACKAGE (U-SQL).
// Will error if not exists USE DATABASE TestReferenceDB; DROP PACKAGE XMLFiles; // Will not error if not exists DROP PACKAGE IF EXISTS TestReferenceDB.dbo.XMLorJSON;