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

how to run 'mysql' commands from a batch file? : Sql dba

1170

What is a design view?

978

How many columns should be in an index?

1014

Explain what is a database?

1134

What is the need of merge statement?

1092

how to convert character strings to numeric values? : Sql dba

1163

what are the types of subquery? : Sql dba

1158

Differentiate pl/sql and sql?

1130

Is sqlite free?

1023

What is #table in sql?

1181

What is out parameter used for eventhough return statement can also be used in pl/sql?

1123

Which query operators in sql is used for pattern matching?

1009

What are the set operators in sql?

1136

How do you create an update query?

1021

Why is pl sql used?

1029