title: Need to drop and recreate SQL table with identity(1:1) on primary key
body: <p>I have a table with some million records. This table has 1:N relation to some other tables and this other tables have also some 1: N relations. Primary key on this table has auto increment i:1 , this primary key is used in those linked tables so i have to retain these id's</p>
  
  <p>I need to recreate the table with some changes. I can recreate the tables but i need some suggestions on How to retain the auto-generated ID's and populate them so it wont break the relationship with other tables? Or is there any other way for this kind of task ?</p>