What is the difference between Primary key and
unique index?

Answer Posted / guest

The primary key is used to establish referential integrity
relationship with another table and a Unique index is used
to to enforce uniqueness.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can one database have multiple instances?

581


How does cobol compile db2 program?

608


Explain about open switch business continuity software?

563


What is dbrm? When it will be created?

598


List some fields from sqlca?

611






What are the full forms of spufi and dclgen and why are they used?

654


What is role in db2?

620


What is difference between alias and synonym in db2?

643


Why select is not preferred in embedded sql programs?

713


Outputs of explain are with matchcols = 0. What does this signify?

617


Is db2 a mainframe?

586


What is the picture clause of null indicator variable?

688


What is page size in db2?

562


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

610


How to create db2 table in mainframe?

629