Copy one Table with Data to another Table in SQL-Server

Copy Table in SQL – Server Management Studio

Here we will learn how to create and copy new table from an existing table in sql server management studio.

Here is a syntax for copy data from one table to other table.

SELECT * INTO NewTableName FROM OldTableName

Here, OldTableName is our old created table  with some data.

and the NewTableName which is after created run the sql query.

Run above query in your sql server we can create new table with copy all the data.

In below screen we write Select * into Tbll from AddressBook, here Tbll is our new table which will be created after run this query and Addressbook is our old table which is created first in sql server. Here all the records are copies from Addressbook table to Tbll Table.

 

Copy Data from one table to other table in sql server
Copy Data from one table to other table in sql server

 

Copy Data from one table to other table in sql server
Copy Data from one table to other table in sql server

 

Copy Data from one table to other table in sql server
Copy Data from one table to other table in sql server

Video tutorial of sql server copy table.

Leave a Reply

Your email address will not be published. Required fields are marked *