Define What Is A Surrogate Key?

1.	Define What Is A Surrogate Key?
Answer» A surrogate key is nothing but a replacement of the primary key within the database. It is CONSIDERED to be a unique IDENTIFICATION factor for each row within a table. It is very helpful because the primary key can change and thus makes it DIFFICULT process to update the data, but not with the surrogate key. A surrogate key is always in the form of a digit or an integer.

Answer»

A surrogate key is nothing but a replacement of the primary key within the database.
It is CONSIDERED to be a unique IDENTIFICATION factor for each row within a table.
It is very helpful because the primary key can change and thus makes it DIFFICULT process to update the data, but not with the surrogate key.
A surrogate key is always in the form of a digit or an integer.

Discussion