March 20, 2003 at 11:31 am
quote:
I don't think there's much difference between the two, because SQL Server actually creates a clustered index to enforce a clustered unique constraint. Create a clustered unique constraint, then query sysindexes by the constraint name. You'll see that an index was created with indid=1, i.e. a clustered index.
Absolutely, this has been discussed above. However my view is that you should use a unique constraint instaed of manually creating a unique index, because a constraint is a logical construct and is visible to users via the logical schema.
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
August 12, 2007 at 6:06 pm
Wow, awesome thread guys... this should be put in the top X best discussions on this forum... now if only they had that coded!!
Viewing 2 posts - 31 through 31 (of 31 total)
You must be logged in to reply to this topic. Login to reply