Unique key can have nulls Primary key cannot have nulls. In a single table we can create multiple unique keys.In a single table we can have only one primary key. ============================================= Unique key creates a non-clustered index by default.Primary Key created a clustered index by default. ================================================ Both unique keys and primary keys can be referenced by foreign key. For more such videos visit http://www.questpond.com
We are also distributing a 100 page Ebook "Sql Server Interview Questions ". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on firstname.lastname@example.org with the shared link and we will email you the PDF.