• subscribe

Choosing a Primary Key


Posted @ 4/2/2010 11:42 AM By Megan Keller

 
Are you unsure whether you should use a surrogate identifier or a natural value for a primary key? Check out Michelle A. Poolet’s article “Surrogate Key vs. Natural Key.” In this article, Michelle discusses the differences between the two types of keys and explains how to choose a primary key, with a focus on the four criteria a natural key or a surrogate key must meet before they’re chosen as the primary key and the key factors that you should consider before choosing a primary key.

For more information about primary keys, see 

SQL by Design: How to Choose a Primary Key 
What Makes a Good Primary Key?

Related Content:

Comments

Add A Comment
    There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here

Blog Archive

  Home