Re: Experience with foreign keys across schemas?

Rick Denoire <100.17706_at_germanynet.de> wrote in message news:<re1qp0hbc4vads0k1b4p2qr5c5cqfbq29g_at_4ax.com>...
> Hello
>
> Today, I was asked to setup a new schema with tables which will
> contain foreign key references to tables in another schema.
>
> I don't like that. I am sure that's wrong, but am missing arguments.
> OK, things like "delete from table <tralala> cascade" or "drop user
> <john> cascade" tend to be dangerous. What else?
>
> Thanks
> Rick Denoire

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.

If your system is built with various business area owners such as sales, manufacturing, financial, distribution etc... then if would seem logical that at times tables within one area will need to reference data in another area for integrity purposes. Just make sure the child table owner has the references privilege granted from the owning table user.

Your objection is without merit.

IMHO -- Mark D Powell -- Received on Fri Nov 19 2004 - 10:06:32 CST