Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Natural Keys
Message
From
02/03/2015 14:30:21
 
 
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:
01616102
Views:
36
>>Also, there are cases- some reference tables for example- where there are no natural keys and enforcing natural keys would be weird.
>
>Theoretically, I'm not sure that's true. There has to be "something" about each row (even if it's a description) that logically constrains the row as unique.
>
>(Or maybe this is just a matter of semantics)

Yes. You're right, people shouldn't duplicate anything.
I've seen business situations where a reference entry was duplicated with no harm done, but that was luck.
It's potentially harmful.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Previous
Reply
Map
View

Click here to load this message in the networking platform