Why do we use Unique Key?

 Posted by vishalneeraj-24503 on 10/7/2014 | Category: Sql Server Interview questions | Views: 458 | Points: 40
Answer:

Unique Keys Identify Record Uniquely:- Enforcing Unique key on column helps user to avoid duplicate records.PAN Number column can be treated as Uniqe Key because it can not be same for different employees.

Even if we have made a unique key and inserting duplicate data in the unique column(s),Sql Server throws the error.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response