Question: How do you resolve the error that says "The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name "dbo.TheName" and the index name "PK_NameHere". The duplicate key value is (1)".
Please Login to see the rest of the answer
Answer: Right-Click on the Primary Index column while in Table Design, then navigate to "Indexes/Keys" and delete the Index that might be causing the error.
If the above does not work, delete the Column that is causing an issue, save the changes then recreate the Column again and make it a Primary Key.
Save your changes using "Save All" icon in Tools tab or press Ctrl+Shift +S all at once.