通过脚本运行修改数据库表的字段默认值

USE  目标数据库[TargetDatabase]
GO
ALTER TABLE [dbo].[TargetTable] DROP CONSTRAINT [TargetDefaultConstraint]
go
alter table [dbo].[TargetTable] add CONSTRAINT [TargetDefaultConstraint] default(defaultvalue) for DefaultField
go