
- DBMS Tutorial
- DBMS - Home
- DBMS - Overview
- DBMS - Architecture
- DBMS - Data Models
- DBMS - Data Schemas
- DBMS - Data Independence
- Entity Relationship Model
- DBMS - ER Model Basic Concepts
- DBMS - ER Diagram Representation
- DBMS - Generalization, Aggregation
- Relational Model
- DBMS - Codd's Rules
- DBMS - Relational Data Model
- DBMS - Relational Algebra
- DBMS - ER to Relational Model
- DBMS- SQL Overview
- Relational Database Design
- DBMS - Database Normalization
- DBMS - Database Joins
- Storage and File Structure
- DBMS - Storage System
- DBMS - File Structure
- Indexing and Hashing
- DBMS - Indexing
- DBMS - Hashing
- Transaction And Concurrency
- DBMS - Transaction
- DBMS - Concurrency Control
- DBMS - Deadlock
- Backup and Recovery
- DBMS - Data Backup
- DBMS - Data Recovery
- DBMS Useful Resources
- DBMS - Quick Guide
- DBMS - Useful Resources
- DBMS - Discussion
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>
Key | ProductID | Price |
505_92 | 1987 | 200 |
698_56 | 1256 | 170 |
304_57 | 1898 | 250 |
458_66 | 1666 | 110 |
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.
- Related Articles
- 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
- Referential Integrity Rule in RDBMS
- Entity Integrity Rule in RDBMS
- Future of RDBMS
- Check whether the specified character has a surrogate code in C#
- Difference between RDBMS and OODBMS
- Difference between DBMS and RDBMS
- Difference between RDBMS and HBase

Advertisements