What is difference between UNIQUE and PRIMARY KEY constraints?

Q

What is difference between UNIQUE and PRIMARY KEY constraints?

✍: Guest

A

An UNIQUE key can have NULL whereas PRIMARY key is always not NOT NULL. Both bears unique values.

2011-12-22, 2587👍, 0💬