Re: Database wide constraint?
From: Lennart <Erik.Lennart.Jonsson_at_gmail.com>
Date: 11 Aug 2006 07:48:59 -0700
Message-ID: <1155307739.739791.12740_at_p79g2000cwp.googlegroups.com>
Date: 11 Aug 2006 07:48:59 -0700
Message-ID: <1155307739.739791.12740_at_p79g2000cwp.googlegroups.com>
Emily Jones wrote:
> I have table 1, whose primary key may be used in table 2 table 3 .... table
> n, as a foreign key.
>
> Is there any constraint that can applied, hopefully once and in one place,
> that ensures that for any particular row in table 1, it's value is used in
> only one other table (though it may be used many times in that one other
> table)?
>
> Thanks, Emily
If I understand you correct this is what you are looking for:
See Joes second post in that thread.
HTH
/Lennart
Received on Fri Aug 11 2006 - 16:48:59 CEST