Thread: Add Primary/Foreign Key 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

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