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