Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Hi Aaron.
>>What is the best (or easiest) way to update a persistent relationship within a DBC in code? All I want to do is change the index used by one of the relationships.
>Check out the ALTER TABLE command.
>Doug
Thanks for pointing me in the right direction, but I'm still having some problems.
I have a "One to Many" relationship:
Table: ITEM
Index: itemcage
Related Table: INV
Related Index: itmcageuic
I want to change the relationship to use index BY_ITEM in ITEM (which already exists), but ALTER TABLE seems to want me to ADD/ALTER/DROP a column just to use the REFERENCES argument. Am I missing something? Any help would be appreciated.
Précédent
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