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

9 votes214 views4 answers
Oracle get table column names
SQL
5 votes197 views4 answers
Traduction
SQL
0 vote226 views1 answer
Sql count matching group by
SQL
14 votes177 views4 answers
Sql compiler
SQL
0 vote222 views1 answer
Postgresql remove new line from string
SQL
0 vote183 views1 answer
Mysql get last 2 month data
SQL
8 votes188 views2 answers
Grant all privileges database postgres to user
SQL
0 vote153 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote195 views1 answer
Mysql insert into select with recursive
SQL
49 votes251 views6 answers
Alter table add column
SQL