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_at_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 - 19:29:35 CEST

This message: [ Message body ]
Next message: Kenneth Downs: "Re: Modelling Considered Harmful"
Previous message: Gene Wirchenko: "Re: Modelling Considered Harmful"
In reply to: Roy Hann: "Distributed key constraints"
Next in thread: jingleheimerschmitt_at_hotmail.com: "Re: Distributed key constraints"
Reply: lennart_at_kommunicera.umea.se: "Re: Distributed key constraints"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message