ALTER TABLE "foreign_table_name" ADD CONSTRAINT "fkey_name" FOREIGN KEY
("fkey_column") REFERENCES "primary_table_name"("primary_key_column_name
") ON UPDATE CASCADE ON DELETE CASCADE
(I think :-)
http://www.commandprompt.com/ppbook/index.lxp?lxpwrap=r22871%2ehtm
http://www.commandprompt.com/ppbook/index.lxp?lxpwrap=x13546.htm
Have fun, Jeff
> List,
> How can I create a Foriegn Key after my table is created? I
> cannot find
> in docs (or google) anywhere.