Re: Primary key on one or two fields

Joe,

Just because it is allowed by SQL-92 does not make it logically correct. If you look at the Foobar examples you posted, they are all under-normalized
(specifically, they are not in 2NF) and suffer from obvious update
anomalies. In a well designed schema, DEFAULTs have no place as a value for a key.

The single row UniversalConstants table is a well-known kludge, which does not prove the need for defaults on the keys. It simply shows the INSERT statement without typing up all the values. I would be interested in seeing a real world scenario which demands the logical design to have a DEFAULT on a key.

-- 
- Anith


( Please reply to newsgroups only )