Re: Remove default value from table definition

From: Walt <walt_askier_at_SHOESyahoo.com>
Date: Mon, 16 Jan 2006 18:18:39 -0500
Message-ID: <jRVyf.2843$yb2.2150@news.itd.umich.edu>

DA Morgan 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)
>> Thanks for your help !

> Go to Morgan's Library at www.psoug.org
> click on Tables
> scroll down to where DEFAULT is in the left column in CAP letters.
> There is a demo that shows you how to do it.

Looks like your demo shows how to set the default value to NULL. In practical terms, this is equivalent to removing the default specification, but it does not actually remove it, i.e. there's still an entry in user_tab_columns.

I'm not that this is a distinction with a difference, but the OP seems to think it is.

//Walt Received on Mon Jan 16 2006 - 17:18:39 CST