- 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.