Re: Database wide constraint?

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:

http://groups.google.com/group/comp.databases/browse_frm/thread/8fb7b3932cf3c8c2/4941ec6b357fb436?lnk=gst&q=celko+vehicle&rnum=3#4941ec6b357fb436

See Joes second post in that thread.

HTH
/Lennart Received on Fri Aug 11 2006 - 09:48:59 CDT