Re: How to add foreign key to a table

alter table TABLENAME

    add constraint CONSTRAINT_NAME foreign key (COLUMN)

       references TABLENAME (COLUMN) <on delete cascade>

Laura Bellini wrote in message <01bd47b3$99625b80$863612ac_at_pw48>...
>Hi -
>
>Can someone please tell me the SQL command(s) for adding a foreign key to a
>table? I want to be able to name the foreign key that I assign as well.
>
>thanks.
>
>
>Laura Bellini
>laura.bellini_at_compaq.com
Received on Wed Mar 04 1998 - 00:00:00 CST