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

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.

Read more: Youtube

Posted via email from Jasper-net