Yes, ofcource the Primary key and unique key with not null are different as below:
1.Primary key will not allow null values whereas the unique key will allow.
2.in a table, there can be only one Primary Key column where as Unique key can be contained with any number of columns.
3.primary key is non-clustered index whereas unique key is a clustered index.
Asked In: Many Interviews |