What is the difference between Primary key and
unique index?
Answer Posted / sunny kalra
Primary key: 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is with ur in db2?
What is reorg?
How do I start db2 in windows?
What is host variable?
What do you mean by between and in? Is between inclusive of specified range values?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is null indicator in db2?
What is bind plan?
Mention the definition of cobol in varchar field.
What are the 2 sqlcodes that are returned?
what is diffrence b/w file-aid tool and file-aid utility???
Who uses db2?
What do you mean by cursor?
What is the reason behind not using select * in embedded sql programs?
what is utility for parm lib