Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Primary Key question
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00307005
Message ID:
00307706
Vues:
30
>Somthing like an account number is fine as a candidate key - something an
>end-user or a customer - say a bank customer who needs to refer to his/her bank
>account number - needs to refer to. Yes, it is a unique number. However, as a
>PK - to use something like an account number as a basis of a relationship
>between database entities - is not correct.

Exactly. To continue the bank metaphor, what happens when the two banks merge? That's when using GUIDs for primary keys starts looking awfully attractive....
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform