SQL SELECT INTO

SQL SELECT INTO statement selects data from one table and inserts it into a different table

Mainly it can be used to keep the backup of the table .

Syntax

SELECT *  INTO new_table_name [IN another_DB] FROM old_tablename