SQLTeam.com | Weblogs | Forums

Not allow duplicate records


#1

I have a table with about 20 fields - I want 6 of them not to allow exact duplicates

I am thinking to make it a unique index but I'm wondering if that's the right way to go about this?
what is the best way to do this?


#2

well, you don't require to use index, you can just create a unique constraint on those fields, that should be better if all you require is not to allow have duplicates.