如何用alter修改一個Table裏面的default值

[piccologoo]

如題

[JafyLiu]

不能更改，只能删除旧列，在新添加的列上设置新的default值

[JafyLiu]

参考
create table #t
(
a int,
b int default(0)
)

insert into #t (a)
values
(1)
insert into #t (a)
values
(2)
insert into #t (a)
values
(3)

select * from #t

alter table #t add c int default(0)

insert into #t (a)
values
(1)
insert into #t (a)
values
(2)
insert into #t (a)
values
(3)

select * from #t

drop table #t

[sdhdy]

ALTER TABLE [dbo].[tablename] drop CONSTRAINT [constraintname]

ALTER TABLE [dbo].[tablename] add
CONSTRAINT [constraintname] DEFAULT ('a') FOR [fieldname]

[zlj113]

ALTER TABLE manage ADD dd1 int DEFAULT 0 WITH VALUES '默认值被设为0