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 : 4116
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