IBM DB2 Question:
What is the difference between primary key & unique index ?
Answer:
Primary : a relational database constraint. Primary key consists of one or more columns that uniquely identify a row in the table. For a normalized relation, there is one designated primary key.
Unique index: a physical object that stores only unique values. There can be one or more unique indexes on a table
Unique index: a physical object that stores only unique values. There can be one or more unique indexes on a table
| Previous Question | Next Question |
| What is a clustering index ? | What is sqlcode -922 ? |