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.
Popularity  (1799 Views)
Picture
Biography - sri sri
asp.net c# sql server