January 24, 2002 10:24 PM

Surrogate Key vs. Natural Key

Rating: (0)
SQL Server Magazine
InstantDoc ID #23449
Does your candidate for primary key pass the four tests?
Readers frequently ask me whether they should use a natural value or a surrogate identifier for a table's primary key. A surrogate key is an artificially produced value, most often a system-managed, incrementing counter whose values can range from 1 to n, where n represents a table's maximum number of rows. In SQL Server, you create a surrogate key by assigning an identity property to a column that has a n...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

'Almost make no sense to real developer. The whole article explained some thing every developer knows, and not touch real diffrence between Surrogate Key and Natural Key, pros and cons of each,etc. '

'Anonymous User- December 03, 2004 '

Did you (Anonymous User) even read the article or did you just skim over the first paragraph or 2? There's no way you can consider yourself a 'real developer' if you read the entire article and still make the statement that you did. Michelle (the articles author) was very clear on what the differences are between the 2 types of keys as well as provide real world examples/descriptions of each. You would of course have to read the whole article to get those details and so if you did not, which I believe is the case, then you should not be criticizing the author in the way you did.

It's also apparent that not all developers 'knows' this material because of they did there would not be numerous postings on the internet groups/forumns about this issue.

Bottom line, if you are going to be critcial then make sure you've reveiwed in full what you are criticizing else you will look foolish to others reading your comments.

WILLIAM7/9/2007 7:25:46 AM


Almost make no sense to real developer.
The whole article explained some thing every developer knows, and not touch real diffrence between Surrogate Key and Natural Key, pros and cons of each,etc.



Anonymous User 12/3/2004 11:32:35 AM


It was a great help, very descriptive, good examples.
Thanks

Aslam Pervez 6/20/2004 10:33:28 AM


Very well stated. easy to follow and understand the explanations.

molly arriaga 6/1/2004 12:33:00 PM


Your font size is too small. My eyesight is good -- corrected to 20/20 with glasses, but I still have to squint.

Also, using IE's "View->Text size->Larger" menu item has no affect. You ignore this value.

Jon Kyle 1/24/2003 11:05:41 AM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS