--一个表中所有字段绑定约束的值
select name from sysobjects
where object_id('Initialization')=parent_obj and xtype='D'
--修改表中某一个字段的默认值
1、首先找出该字段绑定约束的值
set @tablename='表名'
set @fieldname='字段名'
select @name=b.name from syscolumns a,sysobjects b
where a.id=object_id(@tablename)
and b.id=a.cdefault
and a.name=@fieldname
and b.name like 'DF%'
2、再删除该约束
alter table 表名 drop constraint 约束的值
3、重新创建默认值
alter table 表名 add default '新默认值' for 字段名
--------------------------------------------------------
CREATE TRIGGER [UpdatePublic] ON [dbo].[Initialization]
FOR UPDATE
AS
declare @AutoPublic char(5)
declare @name varchar(50)
select @AutoPublic=AutoPublic from Initialization
select @name=b.name from syscolumns a,sysobjects b
where a.id=object_id('Operation')
and b.id=a.cdefault
and a.name='IsPublic'
and b.name like 'DF%'
if @AutoPublic=0
begin
alter table Operation drop constraint @name
alter table Operation add default @AutoPublic for IsPublic
end
else
begin
print 'ni'
end
----------------------------------------------------------
Sp_HomeWork