Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Natural Keys
Message
De
02/03/2015 14:30:21
 
 
À
02/03/2015 14:06:53
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Titre:
Versions des environnements
SQL Server:
SQL Server 2012
Application:
Web
Divers
Thread ID:
01616073
Message ID:
01616102
Vues:
35
>>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform