What is the difference between Primary key and
unique index?
Answer Posted / raghunathan
We can have only one Primary Key for a table(including multiple column) but can have any number of unique indexes in a table( limited to number of columns in that table)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the rules for db2 programming?
What is runstats db2?
What is declare cursor?
Is db2 relational database?
How to access db2 tables in mainframe?
How do I add a column in db2?
Why select is not preferred in embedded sql programs?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
How to create db2 table in mainframe?
What are catalog tables in db2?
What is view db2?
What is db2 bind process?
Is the primary key a clustered index?
What is difference between rollback and commit?
What is bind package and plan in db2?