Create a new table with old table structure

In order to copy the structure of a table to a new table try the following query

Select * into NewTable from OldTable where 1=2  

Here the condition "1=2"  is false. So the data will not be transfered to new table,
but the structure will be created from the old table.
By sri sri   Popularity  (2073 Views)