c# and SQL interview question :- What is the difference between uni

Add to Favourites
Post to:

Description
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.

Discussion
143 Members Recommend
269 Followers

Your Facebook Friends on WizIQ