Re: Adding a Foreign Key

tankgirl@worldonline.es writes:

>   Well I wonder if a Foreign Key can also be added and what syntax does it follow.

ALTER TABLE foo ADD CONSTRAINT bar FOREIGN KEY (col) REFERENCES table(col) etc.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter