RE: foreign key with sinonyms

Posted in 2000

Scott Black — Thu, 10 Aug 2000 09:13:52 -0400 — source: Informix-list mailing list archive (1991-1998)

-----Original Message----- From: FGASPAR [mailto:pgasparNOpgSPAM@sistel.es.invalid] Sent: Thursday, August 10, 2000 4:17 AM Posted To: informix Conversation: foreign key with sinonyms Subject: foreign key with sinonyms Hi all, I have this schema: create synonym table1 for db2:table1; create table2 (col1 integer, col2 smallint); .... How can I define a foreign key into table2 referencing table1 (I have the columns to do this, of course). Tanks in advance. Somebody answer him quick before he fires those tanks he's advancing! (Sorry, the clown's getting to me) ----------------------------------------------------------- Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free! http://www.keen.com