Can we have multiple primary key on the table?

 Posted by vishalneeraj-24503 on 3/5/2014 | Category: Sql Server Interview questions | Views: 1591 | Points: 40

No,we do not have.Because primary key enforces the uniqueness.
So if we are creating any table using create table statement and assigning primary key to more than one column.Then it will not allow.It can be only one in any table.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response