复制表

全部复制select * into NewTable from OldTable

复制结构select * into NewTable from OldTable where 1=2

复制数据insert into NewTable (y1,y2,y3) select y1,y2,y3 from OldTable

原文地址:https://www.cnblogs.com/annabook/p/2986845.html