Re: Poor FOREIGN KEY Constraint-Declaration-Implementation in Informix
In comp.databases.informix article <2cfhp7$jfk@maicgn.SoftwareEngineering>
you wrote:
> Hello YOU out there,
>
>[text deleted]
>
> ALTER TABLE t2 ADD CONSTRAINT FOREIGN KEY (c,d) REFERENCES t1 (b,a);>
It is not necesary to specify the structure of the primary key;
INFORMIX will do it for you (internally) if you use:
ALTER TABLE t2 ADD CONSTRAINT FOREIGN KEY (c,d) REFERENCES t1 ;
>
>[text deleted]
>
> Thanks for any comments.
>
> Achim
>
Max
--
Maximo Maldonado B.
Information Services
ITESM-Campus Monterrey
Mexico
mmaldona@mtecv2.mty.itesm.mx