yes, i agree with Rajesh ,primary key constraint doesn't allow null

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 / sunitha

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

Answer Posted / sunitha

yes, i agree with Rajesh ,primary key constraint doesn't allow null values but unique constraint allows null values.this is the main difference .

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can I speed up sql query?

1006

Can we insert data into materialized view?

991

What is primary key and unique key?

1163

Explain what is a database?

1134

Explain the advantages and disadvantages of stored procedure?

1198

Does pdo prevent sql injection?

990

What is cte?

1020

What is compilation error in pl sql?

1024

What is materialized view. What are different methods of refresh?

1438

Explain select statements in sql?

1106

What is difference between sql and excel?

1176

what is self-join? : Sql dba

1239

What is sql used for?

1164

What are the advantages of pl sql?

1166

Why is pl sql used?

1029