Re: What are cons and pros for using IDENTITY property as PK in SQL SERVER 2000?

"David Portas" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> > living people than VendorID values.  I don't think an identity VendorID
> > value is any more artificial than any other unique way of identifying a
> > vendor, so long as it is assigned the first time a vendor enters the
> > system and is never changed.
>
> But the point is that a "natural" key is verifiable outside of the system.

As soon as one records the generated identity value outside the system, the
key is verifiable outside of the system. All keys are surrogates or
artificial keys. Natural keys are nothing more than familiar surrogates.