Try this
DECLARE @cONSNAME VARCHAR(50), @ColName sysname, @kEYTYPE VARCHAR(10)
DECLARE @SQLString NVARCHAR(500)
DECLARE @ParmDefinition NVARCHAR(500)
DECLARE objCONS CURSOR FOR
(select name, ColName = COL_NAME (OBJECT_ID('table_name'), colid)
from sysindexes idx
inner join sysindexkeys ik on ik.id = idx.id and idx.indid = ik.indid
where idx.id = 485576768)
OPEN objCONS
FETCH NEXT FROM objCONS INTO @cONSNAME, @ColName, @kEYTYPE
WHILE @@FETCH_STATUS = 0
BEGIN
IF (@kEYTYPE = 'UNIQUE')
BEGIN
IF NOT EXISTS(SELECT * FROM SysObjects WHERE id = 485576768 AND xtype = 'UQ')
SET @SQLString = N'ALTER TABLE [''table_name''] WITH NOCHECK ADD CONSTRAINT [@cONSNAME] UNIQUE NONCLUSTERED
(@ColName) ON [PRIMARY]'
SET @ParmDefinition = N'@ColName sysname'
EXECUTE sp_executesql
@SQLString,
@ParmDefinition,
@ColName = @ColName
END
FETCH NEXT FROM objCONS INTO @cONSNAME, @ColName, @kEYTYPE
END
CLOSE objCONS
DEALLOCATE objCONS
Hope this helps , If yes then plz accept and vote the answer. Any queries / questions on this are always welcome.
Thanks & Regards
RDBurmon.Sr.Software Engineer