Re: Help me altering table defination

From: Owais Anjum <owais_anjum_at_my-deja.com>
Date: Mon, 03 Jan 2000 14:03:14 GMT
Message-ID: <84qa6s$787$1@nnrp1.deja.com>

In article <38700581.2C75187_at_ti.com>,
norazman_at_ti.com wrote:
> Hi,
> I have a table with one a date data type.
> Currently that field having a defaut of sysdate.
>
> Ie
> Create table x
> (mydate date default sysdate
> ..
> ..
> );
>
> Is there any easy way I can remove the default without having to
> re-create the table.
> Thanks.
>
>

Alter table x modify mydate date null;

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 03 2000 - 08:03:14 CST