What is the need For Surrogate Key Not Primary 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 For Surrogate Key Not Primary Key ?
Ch Kashif
If a column is made a primary key and later there needs a change in the data type or
the length for that column then all the foreign keys that are dependent on that
primary key should be changed making the database Unstable . Surrogate Keys make
the database more stable because it insulates the Primary and foreign key
relationships from changes in the data types and length.