What is Unique Key in SQL Server?

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

A Unique Key in a table uniquely identifies each and every row and allowing Nulls per column Combination. There are two types of Unqiue Keys:

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


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Akiii on: 6/4/2012 | Points: 10
This is great Sriram..


Thanks and Regards
Akiii

Login to post response