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


Please Help Members By Posting Answers For Below Questions

What is precompiler in db2?

589


What is database alias db2?

613


What does sqlcabc has?

633


What is nvl in db2?

631


define clustering index.

622






Why select is not preferred in embedded sql programs?

715


Explain how can you do the explain of a dynamic sql statement?

659


Explain dclgen.

729


Which isolation level provides highest data integrity?

600


How do you simulate the explain of an embedded sql statement in spufi/qmf?

638


What is an instance in db2?

567


What is difference between rollback and commit?

636


What is buffer pool in the db2 database?

624


How do I add a column to a table in db2?

625


How do I connect my db2 database to ibm?

605