Alter Table Add Foreign Key Problem

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Alter Table Add Foreign Key Problem

Message

24/06/2011 12:34:25

Hugo Ranea
Bc Rapid Transit
Colombie Britannique, Canada

24/06/2011 12:16:06

Simon White
Dcipher Computing
Barrie, Ontario, Canada

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

Re: Alter Table Add Foreign Key Problem

Divers

Thread ID:

01515890

Message ID:

01515901

Vues:

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}"

"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?

"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare

"To die for a religion is easier than to live it absolutely"
Jorge L. Borges

Répondre

Fil

Voir

Click here to load this message in the networking platform