What is the difference between primary key & unique index ?
Answer Posted / mani
Primary key can be defined only one for a table whereas
number of unique indexes can be defined for a table.
primary key can not have null values but unique can have
null values and to remind one null value can never be equal
to another null value.
| Is This Answer Correct ? | 23 Yes | 4 No |
Post New Answer View All Answers
What do you mean by between and in? Is between inclusive of specified range values?
How do you select a row using indexes in db2?
How to find primary key of a table in db2?
What is the picture clause of null indicator variable?
Are views updateable?
What kind of database is db2?
How connect db2 database to datastage?
What is a Foreign Key?
What is meant by explain?
What is bind package and plan in db2?
What are the uses of db2 optimizer?
On which levels locks can be applied?
What is dbrm? What it contains?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Is db2 a programming language?