Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Composite primary keys
Hello,
If I understood it correctly, the VFP database supports the use of a composite primary key only through function-based indexes. So if I take the following situation:
Table A, key A_id (character)
Table B, key B_id (auto-incremented integer)
Table C establishing a m-n relationship between A and B, key (A_id,B_id)
For C's primary key I have to create an index based on a function like A_id+TRIM(STR(B_id))
That is probably what I will often have to do as I will have to add tables using auto-increments to an existing database which is using only character primary keys. It will certainly work. But now, It looks to me as I will be losing all benefits of using the more compact integer keys over the longer character keys. Is there a cleverer way to define a composite key ?
Suivant
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