Database - Data Models into Database Designs - Discussion
Discussion Forum : Data Models into Database Designs - General Questions (Q.No. 13)
13.
A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
Discussion:
3 comments Page 1 of 1.
Taqdeerullah said:
1 decade ago
Surrogate keys are keys that have no “business†meaning and are solely used to identify a record in the table. Such keys are either database generated (example: Identity in SQL Server, Sequence in Oracle, Sequence/Identity in DB2 UDB etc. ) or system generated values (like generated via a table in the schema).
Surya said:
1 decade ago
Surrogate key is a substitution for the natural primary key.
It is just a unique identifier or number for each row that can be used for the primary key to the table. The only requirement for a surrogate primary key is that it is unique for each row in the table.
It is just a unique identifier or number for each row that can be used for the primary key to the table. The only requirement for a surrogate primary key is that it is unique for each row in the table.
Anuradha said:
1 decade ago
What is "surrogate key"?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers