Create a new table with old table structure
By sri sri
Access over 40 UI widgets with everything from interactive menus to rich charts.
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.
Biography - sri sri
asp.net c# sql server