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 the maximum size of varchar data type in db2?

645


What is drop table?

584


What is the difference between drop table and delete table?

550


What is nvl in db2?

626


What is cloudant database?

641






List down the data types in the db2 database.

632


What are concurrency issues?

629


What is load replace in db2?

560


When reorg is used?

672


What are the contents of dclgen?

658


What is bind in db2?

604


What is the difference between bind and rebind in db2?

852


What is bind and rebind in db2?

648


What is collection in db2 bind?

577


Can we update view in db2?

560