Difference between primary key and unique with not null key

Vinay Singh10y ago

Accepted answer

Hi

have a look

By default primary key adds a clustered index

By default unique key adds a non-clustered index

For detail please check the link

Difference Between Primary Key and Unique Key In Sql Server Table

0

manish yadav10y ago

But if we create a Empname column as a clustered index, may be name has some duplicate value, by default sql make it unique or not.

0

Vinay Singh10y ago

You can do but it must contain unique value.

0

manish yadav10y ago

Hello Vijay,

I want to know that, if I create a unique key with not null then I create the cluster Index on that. and I create any column like EmpName as a clustered Index.

0