Right now the best way is probably:
create table newtable ( ... new column info ... )
insert into newtable select * from oldtable;
alter table oldtable rename to old_oldtable;
alter table newtable rename to oldtable;
In the second line, you may not be able to get away with a
* if you're doing more complicated changes of types that
can't automatically converted. And once you're done and
sure everything is working, you can delete the backup of
the old table.
Stephan Szabo
sszabo@bigpanda.com
On Tue, 1 Aug 2000, Cheng Kai wrote:
> Hi,
>
> I want to alter the size of a column, say from char(40) to char(80),
> but it seem that
> the ALTER does not support such operation, nor does it support column
> removing.
>
> How can I do for this ?
>
>
> Thanks
>