Re: Surrogate Keys: an Implementation Issue
Date: Thu, 27 Jul 2006 13:53:02 +0100
> What about compound keys? Compound keys are much more likely to change.
> What if there is more than one candidate key? If the identity changes
> when the key value changes, then what if only one candidate key value
> The fact remains that a natural key, however unlikely, can change. If you
> build software around the assumption that it won't, you're going to get
If one designs a relational database around the assumption that the PK won't change they are a moron.
-- Slainte Craig Alexander Morrison Crawbridge Data (Scotland) Limited "Brian Selzer" <brian_at_selzer-software.com> wrote in message news:tc2yg.75877$Lm5.74940_at_newssvr12.news.prodigy.com... snipped all this 'stuff'Received on Thu Jul 27 2006 - 14:53:02 CEST