Re: Help me altering table defination

Norazman wrote:
> Is there any easy way I can remove the default without having to
> re-create the table.

ALTER TABLE x MODIFY (mydate DEFAULT NULL);

--
Erwin Dondorp
<http://www.dondorp.com/> Received on Mon Jan 03 2000 - 00:55:47 CST