|
View previous topic :: View next topic
|
| Author |
Message |
varun_sharma
New User
Joined: 08 Jun 2005
Posts: 19
Location: new delhi
|
|
|
|
hi
can we update a primary key in a db2 table. im quite sure we can't do this but just wanted to double check with you guys. we can use delete and then insert to change a primary key, but can update be used or some other way?
cheers
varun |
|
| Back to top |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
| No we can't use update to change primary key The only way is to delete arecord & then insert a record with change ( updated primary key value). |
|
| Back to top |
|
|
|
|
