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

0 vote354 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote340 views1 answer
Sql how to display two atributes as one in sql
SQL
1 vote355 views1 answer
Ora-01950 no privileges on tablespace
SQL
0 vote342 views1 answer
Oracle enable chain
SQL
5 votes365 views3 answers
Db begintransaction laravel
SQL
9 votes354 views6 answers
Check constraint in sql
SQL
0 vote353 views1 answer
Changing name of column and datatype in sql
SQL
0 vote357 views1 answer
Sql server on mac m1
SQL
0 vote339 views1 answer
Sql server bool select
SQL
0 vote383 views1 answer
Sqlite unique multiple columns
SQL