This is the simplest way to copy a table into another (new) table in the same SQL Server database. This way of copying does not copy constraints and indexes.
select * into [destination table] from [source table]
Example:
Select * into employee_backup from employee
|
We can also select only a few columns into the destination table like below
select col1, col2, col3 into [destination table]from [source table]
Example:
Select empId, empFirstName, empLastName, emgAge into employee_backup fromemployee
|
Use this to copy only the structure of the source table.
select * into [destination table] from [source table] where 1 = 2
Example:
select * into employee_backup from employee where 1=2
|
Use this to copy a table across two database in the same Sql Server.
select * into [destination database.dbo.destination table] from [source database.dbo.source table]
Example:
select * into Mydatabase2.dbo.employee_backup
from mydatabase1.dbo.employee
|
No comments:
Post a Comment