Is it possible to update a primary key value? If not, what
is the error code given? If yes, can more than 1 primary
key column be updated at a time?

Answer Posted / guest

also remember, you cannot update a primary key when it has
matching foreign key values.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is null value in db2?

795


What is a Foreign Key?

885


How would the varchar column remarks defined?

874


What is cursor stability in db2?

1084


What are the rules for db2 programming?

908


What is meant by explain?

891


When do you specify the isolation level?

819


What is bind and rebind in db2?

923


Which isolation level provides maximum concurrency?

932


How do you select a row using indexes in db2?

885


define clustering index.

837


What is dbrm? When it will be created?

807


What is the maximum size of varchar data type in db2?

898


What is coalesce in db2?

894


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

862