| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: A foreign key on a self-referring table
"Andrea Laforgia" <alaforgia_at_despammed.com> wrote in message news:<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 ?
Why not try it and see? Shouldn't take a minute! Received on Fri Mar 05 2004 - 05:45:24 CST
![]() |
![]() |