alter table TTT drop constraint DF_xxxGOalter table TTT alter column status varchar(16) NOT NULL GOALTER TABLE TTT ADD CONSTRAINT [DF_xxx] DEFAULT ('Planned') FOR StatusGO