复制整张表
select * into NewTableName from OldTableName
只复制列名而不要内容
select * into NewTableName from OldTableName where 1=0
表间数据复制
insert into Table1(zt) select titile from Table2
用SQL语句更改自动编号的字段重新重'1'开始编号
select * into NewTableName from OldTableName
只复制列名而不要内容
select * into NewTableName from OldTableName where 1=0
表间数据复制
insert into Table1(zt) select titile from Table2