Re: Remove default value from table definition

From: Walt <walt_askier_at_SHOESyahoo.com>
Date: Mon, 16 Jan 2006 16:12:13 -0500
Message-ID: <N_Tyf.2838$yb2.2245@news.itd.umich.edu>

Jürg Schaufelberger wrote:

> I want to remove a default value. I tried the following statement:
> alter table myTable
> modify(myColumn default null)
> The default value is now removed, but not the definition.
> Is there a other way to clear the old definition ?
> (Oracle 8.1.7)

Why do you need to remove the definition? The behavior is the same whether you have defined a default value of null or whether you have not defined a default value.

//Walt Received on Mon Jan 16 2006 - 15:12:13 CST