DROP ASSEMBLY

Remove an assembly and all its associated files from the current database.

Syntax
      DROP ASSEMBLY assembly [,...n ]
         [WITH NO DEPENDENTS ] [ ; ]

Key
   WITH NO DEPENDENTS  Drop only assembly_name and none of the dependent/referenced assemblies.
                       default is to drop all dependent assemblies. 

DROP ASSEMBLY returns an error if the assembly is referenced by another assembly in the database or if it is used by a CLR function, procedure, trigger, user-defined type or aggregate in the current database.

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

Example

DROP ASSEMBLY MyCode

"One of the healthiest ways to gamble is with a spade and a package of garden seeds" ~ Dan Bennett

Related commands:

CREATE ASSEMBLY
ALTER ASSEMBLY

Equivalent Oracle command:

DROP PACKAGE


© Copyright SS64.com 1999-2014
Some rights reserved