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

posted on 2010-03-24 16:56  PentiumZ  阅读(156)  评论(0编辑  收藏  举报