Re: Modifying column size

"Stephan Szabo" <sszabo(at)megazone23(dot)bigpanda(dot)com> wrote in message
news:20020719150925(dot)D85491-100000(at)megazone23(dot)bigpanda(dot)com(dot)(dot)(dot)
> In general, not really (as per other answers).
>
> For the specific cases of varchar of one size to varchar of a larger size,
> you can do so with some system table hacking. In general, unless you've
> got constraints/views/etc to prevent you from making a new table, copying
> the data and renaming, I'd suggest against it. (If you really want to
> know, you can ask about it specifically or better yet, check the archives
> :) )

Thanks to everyone for the quick responses!

What I ended up doing is dumping the data, dropping the table (which created
problems, since I had constraints), recreating the table with my changed
varchar size, and restoring the data. I think the suggestion to create a
new table and copying it over is a better solution.....I will still have to
deal with my constraints, but at least there are less steps! :)