Re: Normalization, Natural Keys, Surrogate Keys

From: Bernard Peek <>
Date: Tue, 28 May 2002 17:17:20 +0100
Message-ID: <>

In message <>, Kai Ponte <> writes

>> Having a surrogate primary key shouldn't let you off the hook. As a
>> rule of thumb, you always HAVE TO HAVE an alternate UNIQUE constraint.
>I respectfully disagree with "always have to have." Yes, it may often
>be necessary, but not always.

Can you suggest a situation where you do not need a unique constraint in addition to the surrogate?

Bernard Peek

In search of cognoscenti
Received on Tue May 28 2002 - 18:17:20 CEST

Original text of this message