sql复制表结构,复制表内容语句
select * into b from a where 1<>1
select top 0 * into b from a
insert into a (c1,c2,c3) select d,e,f from b
select * into b from a where 1<>1
select top 0 * into b from a
insert into a (c1,c2,c3) select d,e,f from b
转载于:https://www.cnblogs.com/wswind/p/9876229.html