what is Primary Key in SQL Server

 Posted by Sriramnandha on 6/3/2012 | Category: Sql Server Interview questions | Views: 2488 | Points: 40

A Primary Key in a table uniquely identifies each and every row with out allowing Nulls. There are two types of Primary Keys:

1) Simple Primary Key ==> Defining primary key on a single column is called Simple Primary Key.
2) Composite Primary Key ==> Defining Primary Key on more than one column is called Composite Primary Key.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response