费了好大劲写了个删除并重建约束的SQL脚本，留个纪念！

--删除约束

DECLARE @name varchar(100);

SELECT @name=name FROM sysobjects WHERE parent_obj = object_id('tGlCorpReg')  AND  col_name(object_id('tGlCorpReg'),info) = 'iProType';

IF EXISTS(SELECT * FROM sysobjects WHERE xtype='D' AND name=@name) 

EXEC('alter table [tGlCorpReg] drop constraint '+ @name);

--修改字段不能为空

ALTER TABLE tGlCorpReg ALTER COLUMN iProType int NOT NULL

--设置默认值EXEC('ALTER TABLE tGlCorpReg ADD CONSTRAINT ' + @name + ' DEFAULT(0) FOR iProType');