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