Re: Howto do undo a default clause?

On 31 Jul 2003 18:16:02 -0700, wizofoz2k_at_yahoo.com.au (Nuno Souto) wrote:

>create table zot(
>f1 number default 0,
>f2 date);
>.
>Now, I want to remove the "DEFAULT 0"
>from the table.
>.
>alter table zot modify(f1 ......<wth?>);

alter table zot modify (

    f1 DEFAULT NULL
);

-- 
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)