Add Primary/Foreign Key in 7.3.2
Started by Brian C. Doyleover 22 years ago2 messagesgeneral
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
----------
UMPA
Brian C. Doyle
Director, Internet Services
United Merchant Processing Association
<http://www.umpa-us.com>http://www.umpa-us.com
1-800-555-9665 ext 212
Re: Add Primary/Foreign Key in 7.3.2
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:
Show quoted text
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