NULL value is not allowed
NULL is allowed, subject to the condition that only a single NULL is allowed.
Inserting more null throws “Cannot insert duplicate key” error.
Table can have only one PRIMARY KEY constraint defined
Table can have multiple UNIQUE KEY constraints
By default, if a clustered index is not defined already on the table, defining a PRIMARY KEY constraint results in a clustered index with same name as PRIMARY KEY
By default non-clustered index is create when a UNIQUE KEY constraint is added.
Purpose is to provide a unique identity to each row
Purpose is to avoid duplication
Tuesday, June 28, 2011
Difference between PRIMARY KEY and UNIQUE KEY
Posted by ASP.NET Interview Questions at 12:14 AM