Suresh Chand Jangid Blogs
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment