changing a primary key value
i have a table that has 3 fields as primary key.
is it possible for me to change the value of one
of the primary key.
i am using the UPDATE statement but since
one of the data i am updating is also the PK
i am encountering an error.
isnt it possible to change a data if it is one of the
primary keys ??
[340 byte] By [
ysabelle] at [2007-11-11 10:03:35]

# 2 Re: changing a primary key value
Primary key fields are typically not updated because this can affect data integrity. If one of the columns needs to be updateable then it should be removed from the primary key.