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

Question

Greetings,

How to create duplicate table (structure only) with new name in the same database in SQL Server 2008?

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

I do not want to copy the data!!

Thank you,

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.

Answer 2

SELECT * 
INTO target
FROM  source
WHERE 1 = 2