Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Most of the time a primary key should be generated and not be a combination of other fields. I believe this practice solves far more problems than it causes.
>This post is dealing with my earlier post.
>
>I have a document with a number, revision, and submittal number. This is one table.
>
>A second table holds document items belonging to the documents in the first table.
>
>If I want a one table to many table relation, would it be better to have a field that holds a unique index of the particular document, than to index on the doc, rev, sub no comination.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement