Create Duplicate Table in SQL Server

Hi Vipendra Verma,

There are two ways to create duplicate table from table stored in database in SQL Server:

• Copy table structure as well as records:
  • SELECT * INTO tbl_employee_bkp1 FROM tbl_employee
• Copy table structure only withought records:
  • SELECT TOP 0 * INTO tbl_employee_bkp1 FROM tbl_employee

For more details:

• Creating Duplicate Table With New Name From Existing Table in SQL Server 2012
  • https://www.c-sharpcorner.com/UploadFile/rohatash/creating-duplicate-table-with-new-name-from-existing-table-i/

Hope, this will help you!

hi,

you can create using the below query

select * into teamsnew from teamsold.

Here teamsold-existing table and teamsnew-new one to be created.

But remember it will copy the columns and rows but keys and constraints wont be copied. Best way to achieve this is get table creation script from db and rename the table and keys, constraints name and run it,.

Hi Vipendra,


If we want to copy the structure only

SELECT TOP 0 * INTO newtable FROM oldtable

SELECT TOP 0 * INTO employee1  FROM employee



If we want to copy the structure as well as records

select * into newtable from oldtable

SELECT  *
INTO  employee1
FROM  employee


Thanks