SQL Server Notification Services Question:
Explain the difference between a primary key and a unique key?
Answer:
► 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.
► 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.
| Previous Question | Next Question |
| Define Primary and Unique key? | Define Distributed Query and Linked Server? |