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:

updating the primary key-13

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “updating the primary key”

  1. The following abbreviations and their meanings are some of the most commonly used out there. SETE Smiling Ear To Ear SHID Slaps Head In Disgust SO Significant Other SWAK Sealed With A Kiss SWL Screaming with Laughter SYS See You Soon TA Thanks Again TOY Thinking Of You TTFN Ta Ta For Now TTYL Talk To you Later WB Welcome Back WTH What/Who The Heck YBS You'll Be Sorry YG Young Gentleman YL Young Lady YM Young Man ttyl talk to you later ttys talk to you soon tcob taking care of business ttfn ta ta for now Another thing that was previously mentioned is your text size and appearance.