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 (2148 Views)