Re: integer id columns for all tables
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Wed, 30 Aug 2006 16:14:41 GMT
Message-ID: <RPiJg.6177$9u.72347_at_ursa-nb00s0.nbnet.nb.ca>
>
> Not if one realises that uniqueness is not the only quality a good
> identifier has. See bob's informative list in his post.
Date: Wed, 30 Aug 2006 16:14:41 GMT
Message-ID: <RPiJg.6177$9u.72347_at_ursa-nb00s0.nbnet.nb.ca>
JOG wrote:
>>garhone schrieb: >> >>- If you need uniqueness then use the corresponding constraint. >>Frequently the need for uniqueness in a property leads to the conclusion >>that it should be used as an identifier.
>
> Not if one realises that uniqueness is not the only quality a good
> identifier has. See bob's informative list in his post.
Even better--go to where Bob got his informative list:
http://www.dbdebunk.com/page/page/622344.htm Received on Wed Aug 30 2006 - 18:14:41 CEST