Re: Howto do undo a default clause?

Hi!

I checked, rows con$ didn't increase when defining default values to columns. So, there should be no additional constraints. There's a column DEFAULT$ in COL$ which is LONG datatype, which stores default values (or system functions).

It's possible to use "alter table x modify c1 default null" to make default to null. But this null is stored as string "null" (the name of function) in the LONG, not actually as "nothing". I also tried '' and other stuff, but it didn't help. So it seems that you should alter the defaults to be "null" or if you really-really want to get rid of null functions as well, then start updating col$, which of course is blah blah blah....

Quite interesting issue, though ;)

Tanel.

"Nuno Souto" <wizofoz2k_at_yahoo.com.au> wrote in message news:73e20c6c.0307311716.3889bf5c_at_posting.google.com...
> 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 Fri Aug 01 2003 - 04:49:50 CDT