1) Primary key creates clustered index by default which actually reorders the row in a table based on index while unique key creates non-clustered index.
2) Replication of table possible only if it contains primary key.
RE: What is the need of primary key as opposed to using not null and unique ?
1) Primary key creates clustered index by default which actually reorders the row in a table based on index while unique key creates non-clustered index.
2) Replication of table possible only if it contains primary key.
RE: What is the need of primary key as opposed to using not null and unique ?
1) Primary key creates clustered index by default which actually reorders the row in a table based on index while unique key creates non-clustered index.
2) Replication of table possible only if it contains primary key.
1 
0