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
- 15179 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 is sql injection vulnerability?
How much does a sql dba make? : SQL DBA
what is auto increment? : Sql dba
can a stored procedure call itself or recursive stored procedure? : Sql dba
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
what is a composite key ? : Sql dba
What is sql*loader and what is it used for? : aql loader
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is a string data type in sql?
What is inner join in sql?
What is memory optimized?
How exception handling is done in advance pl/sql?
What is the maximum database size for sql express?
how to fetch alternate records from a table? : Sql dba
What does fetching a cursor do?
