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

7 votes259 views3 answers
How to check table name in current database sql
SQL
0 vote282 views1 answer
Create function in microsoft sql server
SQL
1 vote276 views3 answers
How to truncate table with foreign key constraint
SQL
2 votes276 views1 answer
Oracle kill job by sid
SQL
0 vote257 views1 answer
Implicit inner join table alias with id values
SQL
0 vote253 views1 answer
Mysql autoincrement valor inicial
SQL
0 vote289 views1 answer
Mysql cli output to a file
SQL
0 vote274 views1 answer
Mysql select where field like in list
SQL
0 vote264 views1 answer
Alter table name including schema
SQL
0 vote256 views1 answer
Drop all data from tables
SQL