What is the difference between UNIQUE and PRIMARY KEY?

Answer:

The UNIQUE KEY column restricts entry of duplicate values but entry of NULL value is allowed. In case of PRIMARY KEY columns entry of duplicate as well as value is also restricted.

Asked In :: Wipro TCS iGate Virtusa Accenture Sopra Steria

Priyanka Singh
23 Feb, 2019 5:07 AM

The UNIQUE KEY column restricts entry of duplicate values but entry of NULL value is allowed. In case of PRIMARY KEY columns entry of duplicate as well as value is also restricted.

Reply

Rate This: +1 -0