SQL Server: Natural Key Versus Surrogate Key
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Tue, 15 Feb 2011 07:00:00 UT
Indexed on
2011/02/17
23:31 UTC
Read the original article
Hit count: 196
Filed under:
When designing a database to support applications you need to consider how you are going to handle primary keys. This article explores natural and surrogate keys, and discusses the pros and cons of each, allowing you to determine what makes the best sense in your environment when you are designing your databases.
 |
NEW! SQL Monitor 2.0 Monitor SQL Server Central's servers with Red Gate's new SQL Monitor. No installation required. Find out more.  |
© SQL Server Central or respective owner
