Indexing to avoid duplicates

[chainedtodesk]

i have a few tables in SQL Server2008 that have been in use for a while, i am trying to create indexing on a serial number field to avoid duplicates, i know in access i can change the table field to index no duplicates, in the server do i use the indexes and keys option by right clicking the field and then changing the unique to yes?? will this do what i need or am i totally off base here. thanks

 

[gmmastros]

Changing the index to unique will do what you expect it to. Specifically, it will enforce your data to be unique.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[chainedtodesk]

thank you George for verifying this for me, much appreciated