Re: [GENERAL] Add Primary/Foreign Key in 7.3.2

[Melanie Bergeron]

You can do this by doing
ALTER TABLE mytable
   ADD CONSTRAINT myconstraint FOREIGN KEY (table_id) REFERENCES 
myothertable(table_id);

Melanie

Brian C. Doyle wrote:

Hello all,

I was wondering if there is any way to add a primary and/or foreign 
keys to existing tables in 7.3.2

------------------------------------------------------------------------
 
Brian C. Doyle
Director, Internet Services
United Merchant Processing Association
http://www.umpa-us.com
1-800-555-9665 ext 212




---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])