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
Mention the definition of cobol in varchar field.
What is rct?
What is the difference between drop table and delete table?
Can we insert update delete in view?
How to check table size in db2 sap?
How do I import data from excel to db2?
What is db2 plan table?
Are views updateable?
Explain in brief how does db2 determine what lock-size to use?
What is a cursor in programming?
Highlight all the advantages that are attached to a package.
What is coalesce in db2?
What are db2 tables?
What is lock escalation in db2?
What are the benefits of using the db2 database?