批量删除字段约束及字段的脚本建立方法

select 'alter table ' + b.name + ' drop CONSTRAINT ' + object_name(c.constid) + char(13) + 'alter table ' + b.name + ' drop column ' + a.name + char(13) + 'go' + char(13) + char(13)
from syscolumns a, sysobjects b, sysconstraints c
where a.id = b.id
and b.id = c.id
and a.colid = c.colid
and a.name = 'msrepl_tran_version'
and b.xtype = 'u'
[@more@]select 'alter table ' + b.name + ' drop CONSTRAINT ' + object_name(c.constid) + char(13) + 'alter table ' + b.name + ' drop column ' + a.name + char(13) + 'go' + char(13) + char(13)
from syscolumns a, sysobjects b, sysconstraints c
where a.id = b.id
and b.id = c.id
and a.colid = c.colid
and a.name = 'msrepl_tran_version'
and b.xtype = 'u'

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/3875/viewspace-788695/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/3875/viewspace-788695/