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.
- 7 Answers
- 12985 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / sdp
A table can have multiple UNIQUE CONSTRAINTs but only
one PRIMARY KEY.
| Is This Answer Correct ? | 21 Yes | 1 No |
Post New Answer View All Answers
What does a pl/sql package consist of?
How do I add a database to sql?
Explain lock escalation? : Transact sql
Why we use joins in sql?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
How can we solve sql error: ora-00904: invalid identifier?
How do you truncate?
What are the differences between in and exists clause?
What is primary key in db?
How do I count rows in sql?
How do I partition a table in sql?
What is the difference between alter trigger and drop trigger statements?
Can a select statement fire a trigger?
What are inner outer left and right joins in sql?
How can we implement rollback or commit statement in a trigger?
