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.

System_CAPS_ICON_warning.jpg Warning

This operation cannot be undone!

Syntax
Drop_Assembly_Statement :=                                                                               
    'DROP' 'ASSEMBLY' ['IF' 'EXISTS'] Assembly_Name.

Assembly_Name := Quoted_or_Unquoted_Identifier.

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 optional IF 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.

Example

USE DATABASE SQLSpatial;
DROP ASSEMBLY IF EXISTS SqlSpatial;

See Also

Community Additions

ADD
Show: