foreign key with sinonyms 
Author Message
 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.

-----------------------------------------------------------

Got questions?  Get answers over the phone at Keen.com.
Up to 100 minutes free!
http://www.***.com/



Wed, 18 Jun 1902 08:00:00 GMT
 foreign key with sinonyms

Quote:
 -----Original Message-----

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



Wed, 18 Jun 1902 08:00:00 GMT
 foreign key with sinonyms


Quote:

>  -----Original Message-----

>Tanks in advance.
>Somebody answer him quick before he fires those tanks he's advancing!
>(Sorry, the clown's getting to me)

I thought Carless was the witty one here?
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com


Wed, 18 Jun 1902 08:00:00 GMT
 foreign key with sinonyms

Quote:

> 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).

No.  You could create a trigger or check constraint to do the checking
but watch out if the remote server is ever down!

Art S. Kagel

Quote:
> Tanks in advance.

> -----------------------------------------------------------

> Got questions?  Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Trigger to check a foreign key without using foreign key

2. Trigger to check a foreign key without using foreign key

3. foreign key w/o foreign/primary key

4. Foreign Key as subset of Primary Key

5. Identification of a primary key/foreign key

6. One FOREIGN KEY refrences a Table with two Primary Keys

7. Copying Primary Key to Foreign Key

8. Changing Primary Key Values when foreign key constraints exist

9. delete primary key records together with the foreign keys records

10. Help, foreign keys and index keys

11. Replication with Primary Keys & Foreign Keys Schema

12. Foreign Key and Primary Key Programatic retrieval


 
Powered by phpBB® Forum Software