Re: A foreign key on a self-referring table
From: Andrea Laforgia <alaforgia_at_despammed.com>
Date: Fri, 5 Mar 2004 08:58:19 +0100
Message-ID: <c29bp2$1q225s$1_at_ID-221370.news.uni-berlin.de>
Date: Fri, 5 Mar 2004 08:58:19 +0100
Message-ID: <c29bp2$1q225s$1_at_ID-221370.news.uni-berlin.de>
Thank you for all your answers.
I was imagining it was weird just because I assumed that, whether, for
a strange reason, a record pointed to itself, the DBMS would not allow
to delete it. If I had, for instance:
|--------------------------|
|CustomerID = 100 |(PK)
|--------------------------|
|Name = .... |
|City = ... |
|ZipCode = ... |
|CustomerID = 100 |(FK)
Would the DBMS let delete that record ? Received on Fri Mar 05 2004 - 08:58:19 CET