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
Define check constraint.
Where can you declare a cursor in a cobol-db2 program?
How do I change the column size in db2?
What is the syntax for FETCH in DB2 ?
Explain package in db2 and its advantages?
What is null indicator in cobol db2?
what is the sqlcode -501
How to test SQL -911 error while developing COB-DB2 program
What is cloudant database?
What is iseries database?
What is a db2 package?
How do you select a row using indexes in db2?
How do I start db2 in windows?
What are the uses of db2 optimizer?
What is a storage group (stogroup)?