Have Rows With Exact Content and No Primary Key ? Can’t Delete/Update?
When you have no primary key in a table or had it removed (this could occur through migration process) in addition to two exact rows with same content, you won’t be able to update or delete one row without the other.
The solution is to craft your Own primary to perform the delete/update.
;WITH cte AS ( SELECT ID, row_number() OVER(PARTITION BY ID ORDER BY ID) AS [craftedPK] FROM settings )
Make sure to verify the data before performing the delete / update by selecting the the newly crafted key and data.
SELECT * FROM cte;
Perform the delete.
DELETE cte WHERE [craftedPK] > 1;
I hope you found this helpful.