A table can have compite primarykey but only one unique constraint

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 / chandrasekar.ramasamy

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

Answer Posted / chandrasekar.ramasamy

A table can have compite primarykey but only one unique
constraint

Is This Answer Correct ?

0 Yes

15 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is a join? : Sql dba

1035

Can we join 3 tables in sql?

1043

What are the methods of filing?

935

What are all the common sql functions?

1027

Name some usages of database trigger?

1019

Explain the commit statement.

1159

What is a memo field?

969

Explain unique key in sql.

1012

How many sql commands are there?

1114

what is a composite key ? : Sql dba

1060

How does a trigger work?

1071

explain what is mysql? : Sql dba

1080

What is primary key and unique key?

1121

Explain the working of foreign key?

1067

Explain the update statement in sql

992