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:

> 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