Re: What happens after 2^32 autonum keys are exhausted?



--CELKO-- <jcelko212@xxxxxxxxxxxxx> wrote:

You might want to consider a proper primary key in a logical
data model instead of a physical counter of events in the hardware.
This is favourite theme of yours and nobody would argue against your
preference. What key do you suggest people use when there is no
"proper primary key"? For example, there was once a proper primary key
of Order Number that was printed on the order form. The order is now
entered directly into the supplier's computer, possibly by the
customer's computers. Can you provide a proper primary key that is
superior to a computer generated one?
.