DROP ASSEMBLY (U-SQL)
Updated: March 10, 2017
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.
This operation cannot be undone! |
| Syntax |
|---|
Drop_Assembly_Statement :=
'DROP' 'ASSEMBLY' ['IF' 'EXISTS'] Assembly_Name. |
Semantics of Syntax Elements
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 EXISTSis 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.
Example
USE DATABASE SQLSpatial; DROP ASSEMBLY IF EXISTS SqlSpatial;