Re: How to drop a default value for a column

Hi Kalle

ALTER TABLE xxx
 MODIFY (col1 DEFAULT NULL);

Regards

Mike O'Shea
http://www.strychnine.co.uk

Kalle wrote:
> Hi all,
>
> I have a table
>
> xxx
>
> col1 varchar2(10) default 'x' null,
> col2 varchar2((100) not null
> /
>
> now I would like to drop the default value for col1
>
> How to do it?
>
> rgds
> Kalle
Received on Tue Nov 29 2005 - 03:20:28 CST