Re: Quick way to alter a column type?

["Eric Bangug" <ericbangug@xxxxxxxxx>]

> is there any quick hacks to do this quickly? There's around 20-30million
> rows of data.
>
> I want to change a column type from varchar(4) to varchar(5) or should I
> just use text instead.

ALTER TABLE tablename ALTER COLUMN columnname TYPE VARCHAR(5);

HTH.

-
Eric