declare @csname varchar(100)
set @csname=''
select @csname=[name] --约束名称
from sysobjects t
where id=(select cdefault from syscolumns where id=object_id(N'收支表') and name='收入')
exec('alter table 收支表 drop constraint '+@csname)
declare @csname varchar(100)
set @csname=''
select @csname=[name] --约束名称
from sysobjects t
where id=(select cdefault from syscolumns where id=object_id(N'收支表') and name='收入')
exec('alter table 收支表 drop constraint '+@csname)