Re: Foreign Key question

Posted in 1996

Jonathan Leffler — 12 Jan 1996 12:48:03 -0500 — source: Informix-list mailing list archive (1991-1998)

Gsong, You asked two questions about Foreign Keys... >From: gsong@aol.com (Gsong) >Date: 11 Jan 1996 20:08:40 -0500 >X-Informix-List-Id: <news.20205> >What is the proper method of referencing the primary key of a table in >another database in Informix OL 7.x? >From: gsong@aol.com (Gsong) >Date: 12 Jan 1996 05:32:15 -0500 >X-Informix-List-Id: <news.20216> >How do you make a foreign key constraint to a table outside of the current >database. Is this possible? It is not possible to create foreign key constraints across databases, whether they are colocated in the same server or located in two different servers, as you have already discovered to judge from your questions. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>