- In a table there can be only one column on which we implement Primary Key Constraint while we can implement Unique Key Constraints on more than one column.
- There can be no NULL value in column having Primary Key Constraint while NULL value can be allow in column having Unique Key Constraint.
- In column having Primary Key Constraint Cluster Index created by default while in column having Unique Key Constraint NonCluster Index creates by default.
Showing posts with label Primary key. Show all posts
Showing posts with label Primary key. Show all posts
Tuesday, 12 June 2012
What is the difference between Primary Key and Unique Key
Subscribe to:
Posts (Atom)