--只复制表结构,与源表结构相等,包括主键和索引,
--只可惜只能复制一个主键
--改数据库名,table1 改为旧表,table2改为新表,今天研究了下怎么完全复制一个表,包括表结构,主键和索引。下面是SQL,
--注:两个表在一个库中。这段script可以重复跑
--SELECT * INTO ou_issues_msg_detail FROM Ou_Issues_Msg_Detail_bak
--SELECT * FROM Ou_Issues_Msg_Detail
use DC --DBName
declare @sourceTable as varchar(20)
set @sourceTable = 'it_user' --source table name
declare @destTable as varchar(20)
set @destTable = 'it_user_bak' --destination table name
--select * from dbo.sysobjects where id = object_id('it_user_bak') and OBJECTPROPERTY(id, N'IsUserTable') = 1
if exists (select * from dbo.sysobjects where id = object_id(@destTable) and OBJECTPROPERTY(id, N'IsUserTable') = 1)
exec('drop table &#
复制表结构,与源表结构相等,包括主键和索引
最新推荐文章于 2022-01-01 00:43:59 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)