What Is The Need Of Surrogate Key? why Primary Key Not Used
As Surrogate Key?
Ch KashifEnlightened
Power BI
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this answer should be reported.
What Is The Need Of Surrogate Key? why Primary Key Not Used
As Surrogate Key?
Ch Kashif
Surrogate Key is an artificial identifier for an entity. In surrogate key values are
generated by the system sequentially(Like Identity property in SQL Server and
Sequence in Oracle). They do not describe anything. Primary Key is a natural
identifier for an entity. In Primary keys all the values are entered manually by the
user which are uniquely identified. There will be no repetition of data.