drop-assembly-transact-sql.md

title	DROP ASSEMBLY (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	05/10/2017
ms.prod	sql
ms.prod_service	sql-database
ms.reviewer
ms.technology	t-sql
ms.topic	language-reference
f1_keywords	DROP ASSEMBLY DROP_ASSEMBLY_TSQL
dev_langs	TSQL
helpviewer_keywords	removing assemblies DROP ASSEMBLY statement deleting assemblies assemblies [CLR integration], removing dropping assemblies WITH NO DEPENDENTS option
ms.assetid	452d181a-a8e6-44a3-975d-29966d01b18d
author	CarlRabeler
ms.author	carlrab

DROP ASSEMBLY (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Removes an assembly and all its associated files from the current database. Assemblies are created by using CREATE ASSEMBLY and modified by using ALTER ASSEMBLY.

Transact-SQL Syntax Conventions

Syntax

DROP ASSEMBLY [ IF EXISTS ] assembly_name [ ,...n ]  
[ WITH NO DEPENDENTS ]  
[ ; ]  

Arguments

IF EXISTS
Applies to: [!INCLUDEssNoVersion] ( [!INCLUDEssSQL15] through current version).

Conditionally drops the assembly only if it already exists.

assembly_name
Is the name of the assembly you want to drop.

WITH NO DEPENDENTS
If specified, drops only assembly_name and none of the dependent assemblies that are referenced by the assembly. If not specified, DROP ASSEMBLY drops assembly_name and all dependent assemblies.

Remarks

Dropping an assembly removes an assembly and all its associated files, such as source code and debug files, from the database.

If WITH NO DEPENDENTS is not specified, DROP ASSEMBLY drops assembly_name and all dependent assemblies. If an attempt to drop any dependent assemblies fails, DROP ASSEMBLY returns an error.

DROP ASSEMBLY returns an error if the assembly is referenced by another assembly that exists in the database or if it is used by common language runtime (CLR) functions, procedures, triggers, user-defined types or aggregates in the current database.

DROP ASSEMBLY does not interfere with any code referencing the assembly that is currently running. However, after DROP ASSEMBLY executes, any attempts to invoke the assembly code will fail.

Permissions

Requires ownership of the assembly, or CONTROL permission on it.

Examples

The following example assumes the assembly HelloWorld is already created in the instance of [!INCLUDEssNoVersion].

DROP ASSEMBLY Helloworld ;  

See Also

CREATE ASSEMBLY (Transact-SQL)
ALTER ASSEMBLY (Transact-SQL)
EVENTDATA (Transact-SQL)
Getting Information About Assemblies