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.
====================
Publicize Yourself... Free!
http://saalram.com
====================
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Saalram.com