Re: How to remove a default value from a column

From: <tedchyn_at_yahoo.com>
Date: Wed, 29 Sep 1999 19:57:20 GMT
Message-ID: <7stqun$jn6$1@nnrp1.deja.com>

Jean-Luc, you can modify default using
alter table <tablename> modify (<column_name default <default value>); you can use null for default value. this will take effect for new records added after alter statement and it will not change existing record with old default value. you can always update them. ted chyn

In article <FItquz.1q9_at_ahisinfr.xs4all.nl>, "Jean-Luc" <jeanluc_at_zap.a2000.nl> wrote:
> Probably a simple one;
>
> Does anybody know how to remove a default value from a column?
>
> Thanks in advance, Jean-Luc
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 29 1999 - 14:57:20 CDT