Question

Distinguish between a Primary key and a Unique key in a table.

Answer 1

Answer :-

PRIMARY KEY :-

- It can't accept Null valus.

- It creats clustered index.

- Only one primary key in a table.

UNIQUE KEY :-

- It can accept only one Null value.

- It creates non clustered index.

- More than one key in a table.