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.
DROP ASSEMBLY MyCode
"One of the healthiest ways to gamble is with a spade and a package of garden seeds" - Dan Bennett
Equivalent Oracle command: