You're correct and none of the databases I use often (DB2, MS SQL, PostgreSQL) require primary keys at all. DB2 on i won't even let you put a constraint on a table in QTEMP, which drives me a bit bonkers at times.
coy
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vern Hamberg
Sent: Friday, May 17, 2013 13:07
To: Midrange Systems Technical Discussion
Subject: Re: codd's 12 Rules
As an example, I believe that SQL Server does not require you to have a primary key, although it is assumed that you will.
I could be mistaken, of course.
-snip-
So, while the platform may be capable of supporting those rules, the platform does nothing to force you to write applications that conform to those rules. And there's the rub.
-snip
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
************************************************************************
This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message. Any disclosure, copying, or distribution of this message, or taking any action based on it, is strictly prohibited.
***********************************************************************
midrange.com
