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
- 12984 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
What are the possible values for the boolean data field?
What is the usage of distinct keyword?
What are the different type of joins in sql?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What are the two characteristics of a primary key?
what are aggregate and scalar functions? : Sql dba
What is sql and explain its components?
describe mysql connection using mysql binary. : Sql dba
What is the purpose of cursors in pl/sql?
What is a sql instance vs database?
what is data integrity? : Sql dba
Why functions are used in sql?
how to show all tables with 'mysql'? : Sql dba
Explain what is a field in a database and record in a database?
Why is %isopen always false for an implicit cursor?
