Re: Otional FK in Informix?

Posted in 2000

Obnoxio The Clown — Wed, 06 Dec 2000 13:33:47 -0000 — source: Informix-list mailing list archive (1991-1998)

From: "LuckeLuke" <nguyenq@supernet.ca> > > How can i create an optional Foreign Key in Informix? What i want is >to >create a column c1 (allow null) in a table t2 , and if c1 is not null, it >is >a foreign key to the parent table t1 (only if not null) . You can't. A foreign key must point to a primary key, and a primary key is NOT NULL. _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com