1.复制全部内容
SELECT * INTO newtable FROM oldtable
2.复制表头
SELECT * INTO newtable FROM oldtable WHERE 1=0
3.复制表数据
INSERT INTO newtable SELECT * FROM oldtable
SELECT * INTO newtable FROM oldtable
SELECT * INTO newtable FROM oldtable WHERE 1=0
INSERT INTO newtable SELECT * FROM oldtable