Skip to content

duplicate-tables.md

Latest commit

 

History

History
81 lines (51 loc) · 2.94 KB

duplicate-tables.md

File metadata and controls

81 lines (51 loc) · 2.94 KB
title Duplicate Tables | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.prod_service table-view-index, sql-database, sql-data-warehouse, pdw
ms.reviewer
ms.technology table-view-index
ms.topic conceptual
helpviewer_keywords
copying tables
tables [SQL Server], duplicating
duplicating tables
table copying [SQL Server]
ms.assetid c6b07423-d1e5-4e5e-8681-5088921f5df3
author stevestein
ms.author sstein
monikerRange >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

Duplicate Tables

[!INCLUDEtsql-appliesto-ss2016-all-md]

You can duplicate an existing table in [!INCLUDEssCurrent] by using [!INCLUDEssManStudioFull] or [!INCLUDEtsql] by creating a new table and then copying column information from an existing table.

Important

This operation duplicates only the structure of a table; it does not duplicate any table rows.

In This Topic

Before You Begin

Security

Permissions

Requires CREATE TABLE permission in the destination database.

Using SQL Server Management Studio

To duplicate a table

  1. Make sure you are connected to the database in which you want to create the table and that the database is selected in Object Explorer.

  2. In Object Explorer, right-click Tables and click New Table.

  3. In Object Explorer right-click the table you want to copy and click Design.

  4. Select the columns in the existing table and, from the Edit menu, click Copy.

  5. Switch back to the new table and select the first row.

  6. From the Edit menu, click Paste.

  7. From the File menu, click Savetable name.

  8. In the Choose Name dialog box, type a name for the new table and click OK.

Using Transact-SQL

To duplicate a table in Query Editor

  1. Make sure you are connected to the database in which you want to create the table and that the database is selected in Object Explorer.

  2. Right-click the table you wish to duplicate, point to Script Table as, then point to CREATE to, and then select New Query Editor Window.

  3. Change the name of the table.

  4. Remove any columns that are not needed in the new table.

  5. Click Execute.