Re: A foreign key on a self-referring table

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 - 01:58:19 CST