Introduction of the term surrogate key

Question

Give a brief introduction of the term surrogate key?

Answer 1

A surrogate key is a distinctive identifier in the database either for an entity in the modeled object or word in the database. Application data is not employed to get surrogate key. Surrogate key is within generated key through the current system and is imperceptible to the user. As numerous objects are accessible in the database corresponding to surrogate, surrogate key cannot be used as primary key.