删除约束
declare @name varchar(50)
select @name =b.name from sysobjects b join syscolumns a on b.id = a.cdefault
where a.id = object_id('ewm_lybzrk') -- 表名
and a.name ='hwh' -- 列名
exec('alter table ewm_lybzrk drop constraint ' + @name)
删除约束
declare @name varchar(50)
select @name =b.name from sysobjects b join syscolumns a on b.id = a.cdefault
where a.id = object_id('ewm_lybzrk') -- 表名
and a.name ='hwh' -- 列名
exec('alter table ewm_lybzrk drop constraint ' + @name)