Some Considerations for Assigning a Primary Key |
Post Reply |
Author | |
Steve Schapel
Microsoft MVP Joined: 04 Jul 2009 Status: Offline Points: 10 |
Post Options
Thanks(0)
Posted: 04 Jul 2009 at 12:19pm |
Some Considerations for Assigning a Primary Key in a Database Table
Database developers must decide on how they will allocate primary keys in their database tables.
There are many developers who have strong beliefs about this or that way to do it. In particular, concerning the usage of artificial or surrogate fields. There simply is no consensus on that question, and a definitive statement on it is therefore not possible. I will certainly reveal my own preferences, but it is not my primary intention here to argue the relative merits of natural versus surrogate keys. Instead, the focus here is on attempting to clarify the questions that the developer needs to take into account, and to dispel some of the confusion that I often see around this subject... Read more here: http://accesstips.datamanagementsolutions.biz/primarykey.htm |
|
Steve Schapel
http://accesstips.datamanagementsolutions.biz/ |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |