可以参考以下实例:
表bl_tbl_cardaccountchange的ChargeOperationID建有约束,现在想取消:
alter table bl_tbl_cardaccountchange alter column ChargeOperationID integer
if exists(select 1 from syscolumns c inner join sysobjects t on c.id = t.id where t.name = 'bl_tbl_cardaccountchange' and c.Name = 'ChargeOperationID' and c.domain > 0)
exec sp_unbindrule 'bl_tbl_cardaccountchange.ChargeOperationID'
go