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

DROP ASSEMBLY (U-SQL)

Michael Rys|Last Updated: 5/15/2018
|
4 Contributors

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.

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.

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;

See Also

© 2018 Microsoft