Re: Experience with foreign keys across schemas?

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Tue, 23 Nov 2004 00:10:57 +0100
Message-ID: <32r4q0176j7kalkouknd6il68i404sjsqq@4ax.com>

Mark.Powell_at_eds.com (Mark D Powell) wrote:

>Rick, what does it matter if the FK references a different user
>schema? A FK is a FK. So what if the referenced table owner is a
>different user, the purpose of the FK does not change nor does the way
>it works.

Side effects like objects in one schema becoming invalid because of changes in a different schema would be possible.

This is not a strong arguments against FK across schemas, though.

I am still considering my advice to the colleagues. I see it as a part of the DB development policy.

Rick Denoire Received on Mon Nov 22 2004 - 17:10:57 CST