求一修改表的SQL语句

[hfhaiyan]

我建表的时候忘了写明默认值，怎么样能修改，我用alter table 语句时报错，哪位能指导一下？？？

[beckhambobo]

alter table table_name modify (col_name default ....);

[xu_guanghui]

UP

[huanglianghuanglian]

例：alter table t_101 modify (column varchar2(8) default '0');

[welyngj]

thank you

[火龙岛主]

:)

[hfhaiyan]

恩，谢谢大家，那如果有默认值的想去掉这个默认值怎么做呢？仍然用这个语句修改吗？

[zgh2003]

Try to try
You have to know!