Create table structure from existing table

Question

How to create a new table in which the structure should be the same as another table?

Answer 1

Try:

Select * Into <DestinationTableName> From <SourceTableName> Where 1 = 2

Keep in mind that this won't duplicate any keys or indexes. You must create a Create Script of the table if you wish to copy the full structure. That script can be used to build a new table with the same structure. If necessary, you can also dump the data into the new table.

To generate a Create Script when using Enterprise Manager, simply right-click the table and choose copy. 

I hope this helps you.