Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL difference between a primary key and a unique key?
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


hemant kumar
difference between a primary key and a unique key?
1 Answer(s)      3 years and 10 months ago
Posted in : SQL


What's the difference between a primary key and a unique key?


Advertisement
View Answers

November 15, 2010 at 12:52 PM


Hi,

The column holding the primary key constraint cannot accept null values.whereas column holding the unique constraint can accept null values.

Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index(physical sorting of a database table?s) on the column, where are unique creates a non clustered index (sorted list of references to the table itself.) by default. Another major difference is that, primary key doesn't allow Nulls, but unique key allows one NULL only.

Thanks,



Related Tutorials/Questions & Answers:
Advertisements
 

 

 

DMCA.com