Difference between primary key and unique with not null key

Question

Difference between primary key and unique with not null key.

Vinay Singh · 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

manish yadav · Answer

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.

Vinay Singh · Answer

You can do but it must contain unique value.

manish yadav · Answer

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.