Friday, March 26, 2010

Create a new table with old table structure In SQL SERVER

//Posted By Suresh

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.

No comments:

Post a Comment