copy table structure without data

Question

Hi How to copy table structure without data from one table to another in sql server ?

Rohatash Kumar · Answer

Andrew If you want to copy the table structure with out copy the data. use the following syntax: select * into table_5 from table_1 where 1 = 2 ; The above query displays the the structure of the table with out copy of the data. In the above example table_5 is the new table which contain the structure of the already created table table_1.