'Select Into' command creates a copy of a table from where it is copying along with the values from the original table.
Select Into
The 'Select Into 'can also be used to copy either only certain columns or all columns from the original table.
It can be used to combine data from several tables or views into one table. The structure of the new table is defined by
the properties of the columns of the original tables along with their constraints.
SQL 'Select Into' Syntax
Select column1,column-2,column-3,....column-n
into
new_tableA
from
tableB
The Select Into Example
The 'Employees' tables contains the following columns and their respective data as shown
below.
1 |
Richard Hughes |
4/23/1945 12:00:00 AM |
1 |
1 |
New Orleans |
950.00 |
2 |
Taryn Sinclair |
3/22/1980 12:00:00 AM |
2 |
2 |
San Francisco |
800.00 |
3 |
Ted Horowitz |
3/31/1960 12:00:00 AM |
3 |
4 |
New York |
700.00 |
4 |
Jonathan Douglas |
7/7/1971 12:00:00 AM |
3 |
4 |
Salt Lake City |
600.00 |
5 |
Miranda Leigh |
7/19/1983 12:00:00 AM |
7 |
3 |
New York |
500.00 |
6 |
Jana Rae |
9/23/1976 12:00:00 AM |
8 |
2 |
Houston |
400.00 |
7 |
Lita Rosanna |
9/14/1982 12:00:00 AM |
4 |
6 |
Long Island |
650.00 |
8 |
Colin Flooks |
12/29/1988 12:00:00 AM |
4 |
2 |
Salt Lake City |
600.00 |
9 |
Anthony Frank |
2/22/1988 12:00:00 AM |
9 |
3 |
San Francisco |
750.00 |
10 |
Stephanie Lynn |
7/30/1979 12:00:00 AM |
8 |
2 |
Salt Lake City |
450.00 |
11 |
Jack Martin |
8/25/1985 12:00:00 AM |
NULL |
NULL |
Austin |
500.00 |
The 'EmployeesEngland' table can be created as shown below.
Select EmployeeID,EmployeeName,DateOfBirth,DesignationID,DeptID,City,Salary
into
EmployeesEngland
from
Employees
Note: This command will throw an error if the table already exists as it creates. So in that case, use an insert statement instead of a select command.