--修改字段默认值
1.删除约束条件
alter table Table1 drop constraint [DF_EveryGameLog_Memo]
2.修改默认值
ALTER TABLE Table1 ADD CONSTRAINT [DF_EveryGameLog_Memo] DEFAULT ( '正常') FOR [sdf]
insert into Table1(colum1) values(0);
1.删除约束条件
alter table Table1 drop constraint [DF_EveryGameLog_Memo]
2.修改默认值
ALTER TABLE Table1 ADD CONSTRAINT [DF_EveryGameLog_Memo] DEFAULT ( '正常') FOR [sdf]
insert into Table1(colum1) values(0);