Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: Primary Key and Foreign key in different databases


Message #1 by "Denis Gobo" <dgobo@w...> on Fri, 15 Feb 2002 13:10:15 -0500
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C1B80B.A7FAB120
Content-Type: text/plain

You could do this using a trigger. You might also want to look into using
replication.

regards
David Cameron
nOw.b2b
dcameron@i...

>  -----Original Message-----
> From: 	Denis Gobo [mailto:dgobo@w...] 
> Sent:	Saturday, 16 February 2002 5:10 AM
> To:	sql language
> Subject:	[sql_language] Primary Key and Foreign key in different
databases
> 
> A question was asked to me and I am not sure if it is possible.
> Can I have a relation between 2 tables that are stored in 2 different
databases
>  
> This is what we need to accomplish  we will only insert data in 1 table
if it already exists in the other table
>  
> I know I can accomplish this by writing a trigger
>  
> Thanks in advance
>  
> Denis
$subst('Email.Unsub'). 


  Return to Index