Need to duplicate a TABLE using Microsoft SQL Management Studio 2008
The TABLE needs to duplicate all table row (Primary Key) ID as well.
Duplicating a TABLE using Microsoft SQL Server Management
Viewed 87691
4 Answers
An easy way to copy a table and all of it's data:
SELECT * INTO
[DATABASE_NAME].[SCHEMA_NAME].[NEW_TABLE_NAME]
FROM
[DATABASE_NAME].[SCHEMA_NAME].[OLD_TABLE_NAME]
The SCHEMA_NAME is often
dbo
To duplicate a table and the data rows in the table, right-click on the database that contains the table you want to duplicate, then click 'Tasks' then 'Import Data...". See the screenshot below for visual representation. Then, follow the instructions in the "SQL Server Import and Export Wizard." Select the table to be duplicated as the 'source' and write in a made-up table name of your choice for the 'destination'. When finished on the last screen (see screenshot below), click 'Next', then 'Finish' and the Wizard will show you the progress of the data transfer until complete.
Related