- In the same db as old_table
- the same structure as old table

Did you need backup only data or data and table structure with indexes, triggers, FKs?

IF NOT OBJECT_ID('new_table') DROP TABLE new_table
SELECT *
  INTO new_table
  FROM old_table

MartinaJ


>First, thank you. Where does the 'new_table' gets saved? And what format would it be?
>
>>

>>SELECT *
>>  INTO new_table
>>  FROM old_table
>>

>>
>>MartinaJ
>>
>>>I need to do some testing of changing records in one table. I anticipate many trial and and error runs. So I would like to backup the table before each test and then restore. What is the easiest way to backup just one table and restore it?
>>>TIA.