Updating the primary key
sample: Once a record is created with a primary key, you really shouldn't be updating the primary key.
Additionally, if a data relation is based on the primary key, related foreign key fields in the child tables will have to be updated to maintain referential integrity.The problem is that you need to supply two different values to the same column (i.e. One value is the value to locate the row and the other value is the new value you wish to set the column to.What's you opinion about Update a primary Key in SQL?I have a "link" table with 3 key from 3 other tables.Should the administration let people to edit one of the keys? Add a new line and if you want remove the other line.
Search for updating the primary key:
So really, when the data needs to change, create the PK on an auto-increment field and let people modify the rest of the data, or delete the entire record when necessary.