XLeratorDB/util Online Documentation
AssemblyExists
Updated: 30 October 2008
Use wct.AssemblyExists to determine if the specified assembly exists in the database.
Syntax
SELECT [westclintech].[wct].[AssemblyExists](
<@AssemblyName, nvarchar(4000),>)
Arguments
@AssemblyName
is the name of assembly being tested for on the database. @AssemblyName is an expression of the character string data type category.
Return Types
bit
Remarks
· AssemblyExists simplifies SQL intended to drop an assembly if it exists.
Example
IF (wct.AssemblyExists('myAssembly') <> 0) DROP ASSEMBLY myAssembly
Here is the result set
----------------------
Command(s) completed successfully