A Surrogate Key’s only purpose is to be a unique identifier in a database, for example, incremental key, GUID, etc. It has
Surrogate Key has no actual meaning and is used to represent existence. It has an existence only for data analysis.
Above, the surrogate key is Key in the <ProductPrice> table.
Some other examples of a Surrogate Key −