DROP ASSEMBLY (Transact-SQL)
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.
The following example assumes the assembly
HelloWorld is already created in the instance of SQL Server.
DROP ASSEMBLY Helloworld