SQL –TABLE BACKUP

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.

©2020 by Pavan Lalwani. 

  • Udemy
  • Facebook
  • Twitter
  • YouTube
  • Linkedin