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
- 15171 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / sunitha
yes, i agree with Rajesh ,primary key constraint doesn't allow null values but unique constraint allows null values.this is the main difference .
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of using pl/sql?
what are the drivers in mysql? : Sql dba
Explain the types of joins in sql?
what are date and time functions in mysql? : Sql dba
Define a temp table?
what is foreign key? : Sql dba
What are the types of variable use in pl sql?
What is trigger in sql?
What are primary key and foreign key and how they work?
What is union, minus and interact commands?
Why function is used in sql?
How can you get sql*loader to commit only at the end of the load file? : aql loader
What is embedded sql with example?
what is unique key constraint? : Sql dba
Explain the working of foreign key?
