Unique index on SQL Server is used for UNIQUE KEY constraint enforcement,
therefore, instead of using DROP INDEX index_name; should use ALTER TABLE
table_name DROP CONSTRAINT index_name;

--
--------------
Cheers,
Jun

Reply via email to