THE SELECT INTO statement is use to take a table backup by coping data from one table into a new table.
SYNTAX

EXAMPLE
Let us consider a demo database with table name Persons.
Figure 43.1. PERSONS TABLE


The above Query will create a new Table PersonsBackup in the database and will store the entire information From Persons Table.
Want More SQL Deep Dives