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
- 15181 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 can we submit a form without a submit button? : Sql dba
how to run 'mysql' commands from a batch file? : Sql dba
Can we connect to postgresql using sql developer?
what are the join types in tsql? : Transact sql
What is sql clause?
Can you select everything, but 1 or 2 fields, without writer's cramp?
What happens when a trigger is associated to a view?
What are the different set operators available in sql?
what is rdbms? : Sql dba
What is the clause we need to add in function body to return variable?
What is the purpose of the primary key?
How do I run a sql trace?
What is hibernate and its relation to sql?
What is vector point function?
What is the current version of sql?
