I have 2 tables, and use 1 of the tables to copy into the 2nd table. Both tables have the same Primary Keys. I use a Select into Statement: SELECT * INTO <Target> FROM <Source>
The SQL query works just fine, but, the primary key on the target table gets wiped out. How can I use the SELECT INTO sql and not wipe out the primary key?