You can duplicate an existing table in SQL Server 2014 by using SQL Server Management Studio or Transact-SQL by creating a new table and then copying column information from an existing table.
|
---|
This operation duplicates only the structure of a table; it does not duplicate any table rows. |
In This Topic
-
Before you begin:
-
To duplicate a table, using:
Security
To duplicate a table
-
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.
-
In Object Explorer, right-click Tables and click New Table.
-
In Object Explorer right-click the table you want to copy and click Design.
-
Select the columns in the existing table and, from the Edit menu, click Copy.
-
Switch back to the new table and select the first row.
-
From the Edit menu, click Paste.
-
From the File menu, click Save table name.
-
In the Choose Name dialog box, type a name for the new table and click OK.
To duplicate a table in Query Editor
-
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.
-
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.
-
Change the name of the table.
-
Remove any columns that are not needed in the new table.
-
Click Execute.