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.