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