Showing posts with label Difference between Primary Key and Unique key. Show all posts
Showing posts with label Difference between Primary Key and Unique key. Show all posts
Difference between Primary Key and Unique key?
Posted by Raj
Difference between Primary Key and Unique key?
Primary Key:
1.Primary Key doesn’t allow NULLs values.
2.There will be only one primary key in a table.
3.Clustered index is created in Primary key.
4.Primary key allows each row in a table to be uniquely identified and ensures that no duplicate rows exist.
Primary Key:
1.Primary Key doesn’t allow NULLs values.
2.There will be only one primary key in a table.
3.Clustered index is created in Primary key.
4.Primary key allows each row in a table to be uniquely identified and ensures that no duplicate rows exist.