Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15238 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 different types of sql commands?
what are the types of join and explain each? : Sql dba
What are the string functions in sql?
What is data abstraction in sql?
what is a primary key? : Sql dba
How do I save a stored procedure?
How many clustered indexes can be created on a table?
how to dump a table to a file with 'mysqldump'? : Sql dba
Can you join a table to itself?
What does where 1/2 mean in sql?
What does inner join mean?
Why we use joins in sql?
Write a sql query to get the third highest salary of an employee from employee_table?
Explain what is dbms?
Can we join same table in sql?
