alter table TTT drop constraint DF_xxx
GO
alter table TTT alter column status varchar(16) NOT NULL
GO
ALTER TABLE TTT ADD CONSTRAINT [DF_xxx] DEFAULT ('Planned') FOR Status
GO
转载于:https://www.cnblogs.com/pentiunz/archive/2010/03/24/1693975.html
alter table TTT drop constraint DF_xxx
GO
alter table TTT alter column status varchar(16) NOT NULL
GO
ALTER TABLE TTT ADD CONSTRAINT [DF_xxx] DEFAULT ('Planned') FOR Status
GO
转载于:https://www.cnblogs.com/pentiunz/archive/2010/03/24/1693975.html