Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between primary key & unique index ?
- 6 Answers
- 26738 Views
- Patni, Temenos, I also Faced
- E-Mail Answers
Answer Posted / uddipto banerji
1. Primary Key is a column or a set of columns that uniquely identifies a row.Its purpose RECORD UNIQUENESS
2. Primary Key will not allow duplicate values.
3. Primary Key will not allow null.
4. Primary Key is not compulsory but recommended.
5. Primary Key helps to identify one record from another.
6. Only One Primary Key is allowed per table.
7. Unique Indexes is created automatically if there is Primary Key.
8. One table can combine upto 16 columns in a Composite Primary Key.
9. A table can have more than one Unique Key which is not possible in a Primary Key.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
What are catalog tables in db2?
what is a corelated subquerry?
What is the use of predicate?
How do I add a column in db2?
What is the use of value function?
What type of database is db2?
What action db2 takes when a program aborts in the middle of a transaction?
How do I copy a table in db2?
Why do we use cursor?
What is an instance database?
How to retrieve rows from a db2 table in embedded sql?
What are the different types of base tables?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
Which are the db2 tools to protect integrity of the database?
What is ibm db2 connect?
