Answers

Question and Answer:

  Home  SQL Notification Services

⟩ Explain the difference between a primary key and a unique key?

► Both are defined to ensure unique row.

► Primary key creates a clustered index on the column by default.

► Unique creates a non-clustered index by default.

► Primary key doesn't allow NULLs, but unique key allows one NULL only.

 149 views

More Questions for you: