There is no difference. The One & only Difference is a UNIQUE would

What is the difference between UNIQUE CONSTRAINT and
PRIMARY KEY?

1. There is no difference.
2. A PRIMARY KEY cannot be declared on multiple columns.
3. A UNIQUE CONSTRAINT cannot be declared on multiple
columns.
4. A table can have multiple PRIMARY KEYS but only one
UNIQUE CONSTRAINT.
5. A table can have multiple UNIQUE CONSTRAINTs but only
one PRIMARY KEY.

Question Posted / rajesh.m

7 Answers
14928 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / rajesh.m

There is no difference.
The One & only Difference is a UNIQUE would allow Null
Values where as The Primary Key Not.

Is This Answer Correct ?

15 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1001

What are different clauses used in sql?

1072

Explain what is a database?

1037

what is recursive stored procedure? : Sql dba

929

Is mariadb a nosql database?

1005

Is there a 64 bit version of ssms?

893

What is the difference between explicit and implicit cursors in oracle?

997

What does count (*) mean?

873

How does cross join work in sql?

956

What does where 1 1 mean in sql?

978

Is left join faster than inner join?

1063

What is java sql drivermanager?

1020

Are dml statements autocommit?

983

Is t sql a programming language?

1005

What is a pragma statement?

1200