differences between Primary key and Unique Key Not Null

In simple please check the detail

By default primary key adds a clustered index

By default unique key adds a non-clustered index

For detail please check the link

0

We have to define the column weather it's a primary or uniquer. if you define it as primary then it will not allow to add any null value.

0

hi vijay,

it's treat as same or not, means if we have a unique key with not null, then it work as primary key.

and we create a clustered index on that column.

and we use this field as a reference for foreign key.

0

Hi

The mail difference between primary and unique key in case of cluster

Primary Key

By default, Primary key is clustered index and data in the database table is physically organized in the sequence of clustered index.

Unique key

By default, Unique key is a unique non-clustered index.

0

differences between Primary key and Unique Key WITH Not Null. in case of CLUSTERED Index.