Change primary key value in oracle 2017/07/26 vincent leave a comment i want to modify the value of a primary key (pk) but there are foreign keys (fk) with data.. You can modify a primary key in sql server 2017 by using sql server management studio or transact-sql. you can modify the primary key of a table by changing the column order, index name, clustered option, or fill factor.. Hello, i have a table with having primary key and have data in it. nearly 10 table are referencing the primary key of that table as foreign key. now i want to update value of primary key column. please help me with the same. thanks & regards