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
15212 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

Do prepared statements prevent sql injection?

951

How do I find duplicates in sql?

929

What is a record in a database?

1062

Explain exception handling in pl/sql?

1037

What is the maximum database size for sql express?

1025

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1153

How is indexing done in search engines?

982

Define select, insert, create, delete, update, drop keywords

1049

What is the advantage of nosql?

1061

What do you mean by table in sql?

990

Are pl sql variables case sensitive?

1050

What are the two types of exceptions in pl/sql?

1052

how can we submit a form without a submit button? : Sql dba

988

Is a view faster than a stored procedure?

970

What is the difference between distinct and unique in sql?

950