Re: Surrogate Keys: an Implementation Issue
From: Craig Alexander Morrison <cam_at_microsoft.newsgroups.public.com>
Date: Thu, 27 Jul 2006 13:53:02 +0100
Message-ID: <44c8b72e_at_212.67.96.135>
Date: Thu, 27 Jul 2006 13:53:02 +0100
Message-ID: <44c8b72e_at_212.67.96.135>
> 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
> changes?
> 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
> burned.
>
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