c# and SQL interview question Video :- What is the difference between unique key and primary key?

Posted by Questpond under .NET Framework category on | Points: 350 | Views : 4230
Unique key can have nulls
Primary key cannot have nulls.
In a single table we can create multiple unique keys.In a single table we can have only one primary key.
=============================================
Unqiue key creates a non-clustered index by default.Primary Key created a clustered index by default.
================================================
Both unique keys and primary keys can be referenced by foreign key.



Get Questpond videos on discounted price from ITFunda.com.

Comments or Responses

Login to post response