|
Difference between Primary Key and Unique Key
Difference between Primary Key and Unique Key
- Both Primary Key and Unique Key gives uniqueness of the column on which they are defined.
- By default Unique Key creates a nonclustered index whereas Primary Key creates a clustered index on the column.
- A Primary key value cannot be NULL whereas Unique Key allows only one NULL.
|
User Comments:
Comment By
amit
on
06/24/2010
gr8
Post Your Comment :
|