The PRIMARY KEY cannot be null. you can insert ZERO into that but should

Can a primary key have null values? If we try to insert a
null value in a primary key column, will it work or give an
error code?

Question Posted / satya prasad n

Answer Posted / satya prasad n

The PRIMARY KEY cannot be null. you can insert ZERO into
that but should not be null. It will throw an error if you
try to inserts a NULL.

Is This Answer Correct ?

8 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How will you return the number of records in table?

986

Which component is responsible for processing sql statements and selecting access paths?

1178

How to compare data between two tables in db2?

1138

What is database reorganization?

1185

How to check last update on table in db2?

1097

What is temporal table in db2?

1101

What is buffer pool in the db2 database?

1155

What is null in db2?

1068

How do I import data from excel to db2?

1128

What is clone table?

1114

How to retrieve rows from a db2 table in embedded sql?

1444

Where can you declare a cursor in a cobol-db2 program?

1140

What is the purpose of rollback and commit?

1281

Explain the function of data manager.

1097

What is sqlca?

1131