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
- 12989 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
what is a trigger? : Sql dba
Is sql a programming?
Does truncate need commit?
Can we perform dml on view?
What is the difference between truncate and drop statements?
How sql query is executed?
What are the differences between implicit and explicit cursors?
What is Difference Between Unique and Primary Key Constraints?
How to prepare for oracle pl sql certification?
What is an index in sql with example?
What is the purpose of a sql?
What is difference sql and mysql?
How many sql commands are there?
what are aggregate and scalar functions? : Sql dba
what is a database lock ? : Sql dba
