UFN_INDEXEXISTS
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @INDEXNAME | nvarchar(128) | IN |
Definition
Copy
create function BBDW.[UFN_INDEXEXISTS](@INDEXNAME nvarchar(128))
returns bit
as
begin
declare @EXISTS bit
if exists(select [NAME] from sys.indexes where [NAME] = @INDEXNAME)
set @EXISTS=1;
else
set @EXISTS=0;
return @EXISTS
end