you may want to change the way you are recreating your table. try creating the target table schema with your additional identity column first, then move the data using 'insert into' command.

hope this helps