November 16, 2009 at 5:17 am
Identity column and clustered, unique located on PRIMARY what is the Difference?
What is the diff b/w Pk and Identity column
Thanks
Parthi
Thanks
Parthi
November 16, 2009 at 6:11 am
Read BOL and search on google....
Read these article for Index.
http://www.sqlservercentral.com/articles/Indexing/68563/">http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
-Vikas Bindra
November 16, 2009 at 7:11 am
A primary key uniquely identifies a row.
An identity column is an auto incrementing/decrementing column that has no meaning other than as a row identifier. These columns are often used a surrogate keys so you can replace a multi-column unique key with a a smaller single column unique key for use in foreign key relationships.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply