What is surrogate key?

What is surrogate key?

Surrogate keys are always integer or numeric.  It is useful because the natural primary key can change and this makes updates more difficult .Surrogate key is the basically a type of substitution key for the 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..

Date:2013-01-09 00:00:00

Post Your Answers

User Email:

User Name:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher