Thanks. This is just what I thought. but

if we "drop and recreate", the data there in the old table would be gone.

所有跟帖： 

• Select * into table2 from table1 -oops_yz- ♀ (58 bytes) () 04/27/2009 postreply 11:06:17

• 好！ 谢谢：）。就是想确定一下：没有办法可以直接一步到位？ -戏雨飞鹰- ♀ (0 bytes) () 04/27/2009 postreply 11:10:41