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
- 13000 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
When you have to use a default "rollback to" savepoint of plvlog?
How many commands are in sql?
what is the difference difference between procedure and packages
Define commit?
What is the best sql course?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
Which are sql * plus commands?
What are different types of sql?
What is thread join () in threading?
Does truncate require commit?
Write a sql query to find the names of employees that begin with ‘a’?
What is trigger in pl sql?
Who developed sql?
How do I find duplicates in two columns?
How does a trigger work?
