Re: alter table .... add constraint

[REMI VERVECKEN]

Hallo,

I think you cut and pated from a manual.

The "|" means "or". you can only take one of the commands i.e.

ALTER TABLE tbl1
ADD CONSTRAINT fk1
FOREIGN KEY (col1)
REFERENCES reftbl (refcol);

where <refcol> must be primary and unique.

hope this helps.

Thanks to Peter Brawley, who put me on track.

-------------------------------------------------
Computer Technology Support & Consulting
www.ctsc.de