Re: A foreign key on a self-referring table
From: --CELKO-- <joe.celko_at_northface.edu>
Date: 4 Mar 2004 13:23:57 -0800
Message-ID: <a264e7ea.0403041323.1c26b0dd_at_posting.google.com>
Date: 4 Mar 2004 13:23:57 -0800
Message-ID: <a264e7ea.0403041323.1c26b0dd_at_posting.google.com>
>> That's quite weird, in my opinion, but I wish to know whether it is
acceptable, in general, or they are just violating some database
design principle. <<
It is legal SQL syntax. It is often used to implement a hierarchy and there are better way to do that. Received on Thu Mar 04 2004 - 22:23:57 CET