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
- 14931 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / radhika
A table can hava multiple Unique constraints but only one
primary key.
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
How to know the last executed procedure?
What does trigger mean in psychology?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
How to make a copy values from one column to another in sql?
What is a parameter query?
What are all types of user defined functions?
What is snowflake sql?
How show all rows in sql?
What are the parameter modes supported by pl/sql?
What is the process of debugging?
What are schema-level triggers?
Differentiate between syntax and runtime errors.
What are the constraints available in sql?
What are the indexing methods?
how to create a new view in mysql? : Sql dba
