Re: Quick way to alter a column type?

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