sql語句復制表-sql語句復制表結構-sql復制表數據

select * into [新表名] from [舊表名] 註釋：要帶上原表的前綴 dbo.

復制表(及數據)

create table [新表名] as select * from [舊表名]

復制表結構

create table [新表名] as select * from [舊表名] where 1=2

sql復制表數據

insert into [新表名] select * from [舊表名] 註釋：前提就是舊表和新表都需要在這是百度空間地址： /goodhyj/blog/item/8bd75ab70fdac5b8d8335ac3.html