What is the difference between Primary key and
unique index?
Answer Posted / guest1
Using the Primary Key you can establish referential
integrity. Unix index will be created upon the Primary Key
column, and the data will be seperately placed in the Index
space. If you have not created Unix Index, while accessing
the table it leads to SQLCODE = -540
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we insert update delete in view?
How to find the number of rows in db2 tables?
What is null value in db2?
What is the maximum size of varchar data type in db2?
What is cobol db2?
What is db2 command?
Which isolation level provides maximum concurrency?
What is explain plan in db2?
Explain the function of data manager.
Why do chiropractors use drop table?
What action db2 takes when a program aborts in the middle of a transaction?
How to fetch the last row from the table in SQL (db2)?
What is reorg?
What is difference between rollback and commit?
What is the picture clause of null indicator variable?