Re: Primary -- foreign keys

From: Paul G. Brown <paul_geoffrey_brown_at_yahoo.com>
Date: 10 Aug 2001 17:51:19 -0700
Message-ID: <57da7b56.0108101651.53ac749b@posting.google.com>

prk25_at_yahoo.com (keith) wrote in message news:<adbca63f.0108100550.b176fc5_at_posting.google.com>...
> Hi
>
> I am trying to understand why would anyone want to create the
> following:
>
> create table abc
> (
> x integer primary key,
> y char(20),
> foreign key (x) references abc(x)
> );
>
> What's being accomplished by creating a forein key which references a
> primary key of the same table??? Primary and foreign keys are on the
> same column of the same table????

Working 'round a bug?

(Don't ask what bug, or whether it's a bug in the DBA or the DBMS.)

Pb Received on Fri Aug 10 2001 - 19:51:19 CDT