A complete collection of Sql server Interview Questions,sql server performance,stored procedure, trigger,Sql query,security,ms sql server 2005,database backup,restore,free ebook,tutorials.
May 2, 2008
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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment