Re: unique primary key shared between multiple tables.
Date: Fri, 14 Mar 2003 10:49:37 -0000
"ben" <benc_at_email.arizona.edu> wrote in message
> In one of my database design textbooks, I ran across the following
> PropertyForRent(propertyNo, ownerNo)
> Foreign Key ownerNo references PrivateOwner(ownerNo) and
> This implies that I can make PrivateOwner.ownerNo and
> BusinessOwner.ownerNo unique not just for thier respective tables, I
> can make ownerNo unique across both tables. In other words, no
> PrivateOwner.ownerNo may have the the same value as any
> This would be extremely usefull, but I can't find any way to actually
> implement a shared primary key between tables. How do I do this?