Re: Surrogate Keys: an Implementation Issue

> 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'