LeeFAR
SSCarpal Tunnel
Points: 4644
More actions
November 17, 2003 at 4:22 pm
#83200
What is the difference between a unique constraint and unique index. Reading BOL, it really doesn't explain the differences.
Thanks
skrilla99
SSCertifiable
Points: 5795
November 17, 2003 at 4:29 pm
#482334
Lee,
As far as I understand it, creating a unique constraint on a column actually creates a unique index. Therefore there it would seem that there is no difference.
-Dan B
Antares686
SSC Guru
Points: 125444
November 17, 2003 at 6:40 pm
#482344
You will find relavent information I posted in the following thread http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=10360&CAT_ID=1&FORUM_ID=9&Forum_Title=General&Topic_Title=clustered+constraint+vs+clustered+index
November 18, 2003 at 5:47 am
#482399
Thanks Antares686!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply