Re: Storing "deleted" data

From: x <x_at_not-exists.org>
Date: Tue, 1 Nov 2005 10:03:21 +0200
Message-ID: <dk77gh$ji$1@domitilla.aioe.org>

<zeldorblat_at_gmail.com> wrote in message
news:1130769897.026173.216650_at_g49g2000cwa.googlegroups.com...
> >b)You can try to declare a foreign key reference to one table AND
another.
>
> That doesn't help, though. Consider the following:
>
> create table livePeople (
> personID int not null,
> ...
> )
>
> create table deadPeople (
> personID int not null,
> ...
> )
>
> create table personComment (
> personID int not null,
> commentID int not null
> )

Another thought: partitioned table for People. Received on Tue Nov 01 2005 - 02:03:21 CST