Surrogate Key in RDBMS

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.

Example

<ProductPrice>

Above, the surrogate key is Key in the <ProductPrice> table.

Other Examples

Some other examples of a Surrogate Key −

• Counter can also be shown as Surrogate Key.
• System date/time stamp
• Random alphanumeric string.

Ricky Barnes

Published on 04-Jul-2018 08:01:25

• Related Questions & Answers
• Composite Key in RDBMS
• Secondary Key in RDBMS
• Super Key in RDBMS
• Candidate Key in RDBMS
• Alternate Key in RDBMS
• Foreign Key in RDBMS
• Unique Key in RDBMS
• RDBMS terminologies
• Future of RDBMS
• Referential Integrity Rule in RDBMS
• Entity Integrity Rule in RDBMS
• Difference between RDBMS and MongoDB
• Difference between RDBMS and OODBMS
• Difference between DBMS and RDBMS
• Difference between RDBMS and HBase