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.keen.com
FGASPAR wrote:
>
> 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
> Tanks in advance.
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com