title: How to Reorder/Reset auto increment primary key with foreign key?
body: <p>I have two tables like below.</p>
  
  <p>Person table with primary key and address table with primary key and the foreign key with the id of person table's primary key.</p>
  
  <p>Both tables have missed some rows in between like 1,3,6....
  some rows(4 and 5 ) have been deleted.</p>
  
  <p>Now I need to rearrange primary keys in both tables and also after changing primary keys, foreign keys also need to be changes as to new primary keys.</p>
  
  <p>please help.</p>