批量删除索引、约束、列

icon
–drop rowguid indexes 

select 'drop index ' + sysobjects. name + '.' + sysindexes. name from 

sysindexes 

inner join sysobjects 

on sysindexes. id = sysobjects. id 

where objectproperty ( object_id ( sysobjects. name), 'IsMSShipped' ) = 0 

and sysindexes. indid > 0 and sysindexes. indid < 255 and ( sysindexes. status & 

64)= 0 

and index_col ( sysobjects. name, sysindexes. indid, 1) = 'rowguid' 

order by sysindexes. indid 

  

–remove rowguid default constraints 

select 'alter table ' + b. name + ' drop constraint ' + a. name from 

sysobjects a 

inner join syscolumns on syscolumns. id = a. parent_obj 

inner join sysobjects b on syscolumns. id = b. id 

where syscolumns. name = 'rowguid' 

and objectproperty ( object_id ( b. name), 'IsMSShipped' ) = 0 

and a. xtype = 'D' 

  

–remove rowguid columns 

select 'alter table ' + sysobjects. name + ' drop column rowguid ' from 

syscolumns 

inner join sysobjects on syscolumns. id = sysobjects. id 

where syscolumns. name = 'rowguid' 

and objectproperty ( object_id ( sysobjects. name), 'IsMSShipped' ) = 0 

 
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值