Is there a way to alter a varchar column’s length? Maybe something like “alter table foo alter column xyz varchar(256)”.
My alternative seems very messy...
- alter table, add a new column with the desired varchar length. call it “temp”
- insert into “temp” the value of the old column.
- alter table, drop the old column (messing up all the indexes on that column in the process I suppose)
- alter table, add a new column with the same name as the one you just deleted, only with the desired length
- insert into that new column the value in “temp”
- alter table, drop “temp”
- recreate all the indexes
Thanks
-dave