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
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