PRIMARY KEY AND UNIQUE KEY are similar except it has different functions. Primary key makes the table row unique (i.e, there cannot be 2 row with the exact same key). You can only have 1 primary key in a database table. Unique key makes the table column in a table row unique (i.e., no 2 table row may have the same exact value). You can have more than 1 unique key table column (unlike primary key which means only 1 table column in the table is unique). Primary Key Unique Key It will not accept null values One and only one Null values are accepted. There will be only one primary key in a table More than one unique key will be there in a table. Clustered index is created in Primary key Non-Clustered index is created in unique key. Primary key allows each row in a table to be uniquely identified and ensures that no duplicate rows exist. Unique key constraint is used to prevent the duplication of key values ...
To Share Experiences of upcoming Microsoft Technologies...