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
- 14919 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / andsens
Fields in UNIQUE CONSTRAINTs can be NULL. They cannot with PRIMARY KEYs.
You can define more than one UNIQUE KEY in a table.
Because of this, the behaviour of UNIQUE CONSTRAINTs is very different from PRIMARY KEY constraints. As long as one of the fields in a UNIQUE CONSTRAINT is NULL the constraint itself does not apply and you can set the other fields to whatever you want without getting an error.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What does a pl/sql package consist of?
How do I run a sql query in pgadmin 4?
What does where 1/2 mean in sql?
What is sql and its types?
Why is a primary key important?
How many row comparison operators are used while working with a subquery?
What does count (*) do in sql?
Explain what is sql?
What is a clob in sql?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is a temporal table?
Is natural join same as inner join?
What is sql constant?
What is the mutating table and constraining table?
