Enforce a unique constraint on a table with duplicate values
I have a table with duplicate values in a column. I want to make the column unique, but sql wont do it until i remove the duplicate values
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Kirtan PatelPosted Oct 23, 2009, 11:18 AM
Friend,
Here Microsoft's Article About Removing Duplicate to Apply Constaints
http://support.microsoft.com/kb/139444
and check " Do you like this answer" if it helps you :)
patrickPosted Oct 23, 2009, 11:11 AM
Kirtan PatelPosted Oct 23, 2009, 11:06 AM
You have to remove Duplicate Values or Make Them NULL . because its totally against the Rules Of RDBMS :)
if my answer helped you check "do you like this answer"