Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Natural Keys
Message
From
09/03/2015 06:58:59
Timothy Bryan
Sharpline Consultants
Conroe, Texas, United States
 
 
To
07/03/2015 12:53:47
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Environment versions
SQL Server:
SQL Server 2012
Application:
Web
Miscellaneous
Thread ID:
01616073
Message ID:
01616476
Views:
42
>>Here at my job we have a database modeler in our group. He is insistent that all tables use 'Natural Keys' and not surrogate keys.
>
>Politics can be hard.
>
>Perhaps an appeal to authority may help?
>
>Here is the SQL guru Joe Celko discussing the issue - with references back to Codd:
>
>http://www.informationweek.com/software/information-management/celko-on-sql-natural-artificial-and-surrogate-keys-explained/d/d-id/1059246?
>
>We all know this, but here is the kernel of the argument - the article says it better than I can:
> "If users can get to the surrogate key, they will screw up the data integrity "

Michael,
Thanks for the link. I will read it after a bit this morning.
Timothy Bryan
Previous
Reply
Map
View

Click here to load this message in the networking platform