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

Mention some fields that are a part of sqlca.

603


List out the buffer pools in db2

634


How to restart a DB2 program?

1368


What is node in db2?

610


Explain various types of locks in db2?

693






How to view db2 table structure?

597


Define predicate?

645


what is the sqlcode -501

11314


What is the syntax for creating a table in the db2 database?

628


What is cursor in dbms?

595


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

716


What is consistency token in db2?

646


What is meant by dclgen?

620


What is concurrency?

711


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

660