Are you actually dropping the original table?

In the "Select into" you get all the data. As long as you don't drop the original table, if you want to back off the the import, you would just do:

TRUNCATE TABLE TableName

GO

INSERT INTO TableName

SELECT *

FROM NewTableName

GO

The indexes, keys etc. should automattically regenerate ont the re-isnert.

If you want to be absolutely sure then you have to script the table and indexes throught the enterprise mansger or from the query anlyzer, change them all to the NewTableName

run the scripts and then do:

INSERT INTO NewTableName

SELECT *

FROM TableName

GO