DROP ASSEMBLY (U-SQL)
Summary
The DROP ASSEMBLY
statement drops an assembly and any of its associated resources and files.
Note that dropping an assembly is not checking for dependencies of other assemblies on the assembly to be dropped.
Warning
This operation cannot be undone!
Syntax
Drop_Assembly_Statement := 'DROP' 'ASSEMBLY' ['IF' 'EXISTS'] Assembly_Name.
Assembly_Name := Quoted_or_Unquoted_Identifier.
Remarks
Assembly_Name
Specifies the quoted or unquoted identifier of the assembly to be dropped from the current static database context.IF EXISTS
If an assembly of the given name does not exist, or the user has no permissions to drop the assembly, an error is raised. If the optionalIF EXISTS
is specified, then the statement drops the assembly if it already exists, or succeeds without changes if the assembly does not exist or the user has no permission to at least enumerate all existing assemblies.
Examples
- 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.
USE DATABASE SQLSpatial;
DROP ASSEMBLY IF EXISTS SqlSpatial;