×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> wrote on 08/01/2019
02:13:01 AM:
An identity column is a surrogate key by definition!
It depends upon your perspective. I'm not arguing with your
definition. I agree that from a business standpoint the identity key is a
surrogate for the key which makes sense to the business -- such as a
customer number. But, from a database standpoint, the customer number is
a surrogate for the identity key because the identity key cannot be
changed without deleting and re-adding the row. A surrogate can be
changed. A primary key cannot. I also agree that you're not likely to
change a customer number from a business standpoint -- but you could. From
a database standpoint, the fact that you *can* change the customer number
makes it a surrogate of the primary key.
Sincerely,
Dave Clark
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
