title: Update primary key in one table which is foreign key in another table
body: <p>I have a table that it's primary key is foreign key in 5 tables.I need to change the value of this primary key field.what's the query?</p>
  
  <pre><code>             Table1 &gt;&gt; fields: tbl1ID(pk, bigint),  Desc(nvarchar(50))
               Table2 &gt;&gt; fields: tbl2ID(pk, bigint),tbl1ID(fk, bigint),  Desc(nvarchar(50))
               Table3 &gt;&gt;....
               .
               .
               .
  </code></pre>
  
  <p>I've set  tbl1ID=1 and now i need to change it like this tbl1ID=100001,
  but i cant because this field is related to another table.</p>
  
  <p>is it possible to change all of them?</p>