Howto do undo a default clause?

create table zot(
f1 number default 0,
f2 date);
.
.
.

Kewl!
Now, I want to remove the "DEFAULT 0"
from the table.
.
.
.

alter table zot modify(f1 ......<wth?>);
.
.
.

<don't tell me the darn thing is a hidden contraint!>

TIA for any help.
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

PS: Of course, all usual avenues of doco have been exhausted b4 coming here. 8ir3, same in 9ir2. Received on Thu Jul 31 2003 - 20:16:02 CDT