I'm sorry, you're definitely right. wrong forum 🙂 and script is not completed, just a stub. Thank you.

CREATE proc drop_index_if_exists

-- ===================================================================

-- Author: Sergei Krasnov

-- Create date: 1/27/2009

-- Description: delete index/PK if exists

-- ===================================================================

(

@idx_name sysname,

@schema_name sysname,

@tbl_name sysname

)

AS

BEGIN

DECLARE @sql_cmd nvarchar(max);

DECLARE @is_pk bit

select @is_pk =...