Re: Question on Primary Keys

There are database "gurus" who claim that you should never ever use class attributes as primary key.
Instead you add a DBMS-generated primary key value column to each and every table. They even claim that these keys should be unique within the database; if a Client_Num value 12345 exists, you should not use Order_Num 12345.
The reason was that primary key values may never change (agree) and that an object might become of a different class sometime (disagree; I've never seen Clients who became an Order).

(I burned this book, I must add)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 16 2000 - 14:11:52 CEST