> > 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
