SQL复制整张表
select * into NewTableName from OldTableName
select * into NewTableName from OldTableName
只复制列名而不要内容
select * into NewTableName from OldTableName where 1=2
select * into NewTableName from OldTableName where 1=2
表间
数据复制
insert into DT(,...column) select a,b,c... from ST
insert into DT(,...column) select a,b,c... from ST