Here is store procedure i want to insert primary key value , and the pk is not auto key value, basicaly i want to insert abcd into cenmst table in column cennbr, but. Answer / guest. primary key value can be updated as well provided the value you update it with identifies it uniquely.. Update primary key; breadcrumb. announcement. please let me know how can i update a record in the primary key field which behaves as a foreign key to other tables without altering (disabling) the primary/foreign constraint???? please reply sooon yours faithfully, sachin jain ..
I am using sql server management studio and i want to change an auto increment primary key value of a table row, with a different value. sql server management studio after opening the table for edit, shows this field grayed for all rows, of course.. Why would a primary key value change? up vote 18 down vote favorite. 3. if you were using a person's name as a primary key and their name changed you would need to change the primary key. this is what on update cascade is used for since it essentially cascades the change down to all related tables that have foreign-key relationships to the. You changed a primary key value in a datatable and updated the change back to the underlying data source, but the value in the data source remained unchanged. you need to update a primary key value in the data source underlying the datatable..
