How to take a back up of single table and restore it back when I required.
I mean,I need back of single table with all the indexes,constraints and data associated with that table. because I want to modify some of the data of the base table,before doing any modifications to the base table, I want to take backup. when I use select * into table2 from table1 where 1=1 giving the table and its data, but the constraints and indexes associated with that table are not coming.