In this article we will explain how to copy a SQL Server table data and table structure as a New Table in SQL Server Same Database with Example.
In SQL Server If you want to copy a SQL table into another table in the same SQL server database, it is possible by using the select statement INTO keyword.
The syntax of copying table from one to another is given below:
SELECT * INTO <destination_table> FROM <source_table>
For example, you can write following command to copy the records and table structure of employee table into Database as a new table Newemployee table.
select * Into Newemployee from employee
I hope this article will help to tou.