The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name "dbo.TheName" and the index name "PK_NameHere"


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)".

 


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.






For peering opportunity Autonomouse System Number: AS401345 Custom Software Development at ErnesTech Email AddressContact: [email protected]