Into operator in sql

-- INTO copies specified columns into a new table
SELECT *
INTO newtable [IN externaldb]
FROM oldtable
WHERE condition;

SELECT column1, column2, column3
INTO newtable [IN externaldb]
FROM oldtable
WHERE condition;

Eg: SELECT * INTO CustomersBackup
	FROM Customers;
    
    SELECT * INTO CustomersBackup IN 'Backup.mdb'
	FROM Customers;
    
    SELECT CustomerName, ContactName INTO CustomersBackup2017
	FROM Customers;

Similar codes

-1 vote66 views3 answers
Ubuntu install mssql
SQL
5 votes114 views1 answer
Sql use database
SQL
1 vote121 views3 answers
Reset sql primary key
SQL
0 vote122 views1 answer
Match end of string regex sql
SQL
1 vote155 views1 answer
Mysql tables max count
SQL
0 vote153 views1 answer
Postgresql alter table sequence
SQL
1 vote118 views1 answer
Sql select row with max date
SQL
1 vote132 views2 answers
Copy table in sql
SQL
0 vote141 views1 answer
Postgres full text search example
SQL
22 votes125 views6 answers
Create sql table
SQL