|
Search:
Advanced search
|
Browse by category:
|
Glossary | Contact Us |
![]() |
What's the difference between a primary key and a unique key? |
||||
Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index on the column , where are unique creates a nonclustered index by default. Another major difference is that, primary key doesn't allow NULLs, but unique key allows one NULL only. |
||||
Powered by
DBNest.com (Nest of DB Professionals)
