Hi,
How to copy table structure without data from one table to another in sql server ?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Rohatash KumarPosted Jul 27, 2011, 12:11 AM
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.