Primary Key cannot have NULL values in it wherein an UNIQUE index can hav

What is the difference between primary key & unique index ?

Question Posted / shankar

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

Please Help Members By Posting Answers For Below Questions

What are iseries servers?

1075

What is dclgen in db2?

1150

What is the syntax for seeing the columns and data types of a table in the db2 database?

1169

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

1185

What is catalog database in db2?

1166

How do I delete a table in db2?

1074

How to check sequence on a table in db2?

1064

Define check constraint.

1079

What are the 2 sqlcodes that are returned?

1190

What are types of indexes?

1076

What is deadlock in db2?

1070

What does db2 stand for?

1026

What is bind package and plan in db2?

1053

What does sqlcabc has?

1058

What is db2 optimizer?

1239