How to create duplicate table with new name in SQL Server 2008

Question

How do I create a duplicate table with only the structure duplicated with a new name in SQL server 2008?

I have table with 45 fields so I want to create new with same structure but new name.

question from:https://stackoverflow.com/questions/3241801/how-to-create-duplicate-table-with-new-name-in-sql-server-2008

Answer 1

Right click on the table in SQL Management Studio.

Select Script... Create to... New Query Window.

This will generate a script to recreate the table in a new query window.

Change the name of the table in the script to whatever you want the new table to be named.

Execute the script.