--a.colid为0时为表约束 declare @s nvarchar(40) set @s='' select @s=@s+ 'alter table '+object_Name(a.id)+' drop constraint '+object_Name(constid)+char(10) from sysconstraints a join syscolumns b on a.ID=b.ID and a.colid=b.colid where a.ID=object_id('表名') and b.Name='列名'print @s--显示生成语句 exec (@s) --查表约束 select [索引名]=object_name(constid),* from sysconstraints where colid=0 and ID=object_id('表名')
declare @s nvarchar(40)
set @s=''
select
@s=@s+ 'alter table '+object_Name(a.id)+' drop constraint '+object_Name(constid)+char(10)
from
sysconstraints a
join
syscolumns b on a.ID=b.ID and a.colid=b.colid
where
a.ID=object_id('表名') and b.Name='列名'print @s--显示生成语句
exec (@s)
--查表约束
select
[索引名]=object_name(constid),*
from
sysconstraints
where
colid=0 and ID=object_id('表名')