Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Alter Table Add Foreign Key Problem
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01515890
Message ID:
01515909
Vues:
50
All I want to do is add a new index tag to the UPSystem table so there is no reference to a master table basically all I wanted was the equivalent of:
Index On Upper(Module+Name) Tag Name
However I could not see just how that might done using the Alter table .

Thanks,
Simon

>Simon, you need to reference the "master" table, something like:
>
>
>      Alter Table UPSystem Add Foreign Key Upper(Module+Name) Tag Name REFERENCES someOtherTable
>
>* optionally you can use a tag here if you do not want to use someOtherTable's PK by adding at the end of the previous command "tag {someOtherTable's existing tag}"
>
>
Simon White
dCipher Computing
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform