What is the difference between primary key & unique index ?

Answer Posted / shankar

Primary Key cannot have NULL values in it wherein an
UNIQUE index can have one NULL value in it.

Is This Answer Correct ?    37 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a Foreign Key?

661


What is the difference between cursor and select statement?

617


How to create backup table in db2?

647


What is dclgen (declaration generator)?

605


What is runstats db2?

586






What do you mean by between and in? Is between inclusive of specified range values?

670


How to find the maximum value in a column in the db2 database?

614


i want to maintain uniqueness on pdf without make lf??????????

1637


What is db2? Explain.

606


Define predicate?

645


Why select is not preferred in embedded sql programs?

715


What is the reason behind not using select * in embedded sql programs?

606


What is the default page size of buffer pools?

650


What does db2 blu stand for?

663


What is database manager in db2?

555