Question: what is the difference between primary key and unique key with not null?
Answer: The not null constraint is by default added to primary key, it means, primary key attribute cannot accept null values, whereas, the attribute declared as unique can accept null values. It is the major difference between the two. ... Contrary to PRIMARY key UNIQUE constraints can accept NULL but just once.