Print Page | Close Window

Some Considerations for Assigning a Primary Key

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Schapel, Steve
Forum Description: Steve Schapel's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=473
Printed Date: 19 Mar 2024 at 6:09am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: Some Considerations for Assigning a Primary Key
Posted By: Steve Schapel
Subject: Some Considerations for Assigning a Primary Key
Date 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 - http://accesstips.datamanagementsolutions.biz/primarykey.htm



-------------
Steve Schapel
http://accesstips.datamanagementsolutions.biz/ - http://accesstips.datamanagementsolutions.biz/



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net