Re: What is the use of a primary key?
From: David Cressey <david_at_dcressey.com>
Date: Sun, 01 Dec 2002 20:36:00 GMT
Message-ID: <QouG9.302$0I3.33311_at_petpeeve.ziplink.net>
Date: Sun, 01 Dec 2002 20:36:00 GMT
Message-ID: <QouG9.302$0I3.33311_at_petpeeve.ziplink.net>
> If I can recall correctly DB2 was the first SQL-database system to
> implement primary keys and that was
> not until version 1.3, in 1997 - 18 years later! The standard did not
> have primary keys until
> SQL-92!! Can hardly blame Codd on that one.
My recollection is that Oracle and DEC Rdb both had primary keys declarations in 1994.
My expectation would be that DB2 had primary keys earlier than these two
products.
1997 sounds a bit late to me, but I haven't worked with DB2 so I will defer
to others.
Received on Sun Dec 01 2002 - 21:36:00 CET