Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Distributed key constraints

Re: Distributed key constraints

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 26 Apr 2005 10:29:35 -0700
Message-ID: <1114536574.971778.305500@f14g2000cwb.googlegroups.com> 





Roy, if I understand your post correctly you are asking if any rdbms
product supports FK to a remote database table.  My answer is not to my
knowledge.  Oracle definitely does not.  You have to use a table
trigger to enforce integrity between tables in distributed databases.
I do not ever remember dealing with a FK to a remote object with DB2 or
SQL Server either but my experience with those products in not as deep.



HTH -- Mark D Powell --
Received on Tue Apr 26 2005 - 12:29:35 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US