>

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

Hi Martina,

This is good way, but we may also want the indexes, etc. So, I would recommend to script the table, upload that script into another database along with the data the same way you wrote.