Re: Smartest way to resize a column?

On Mon, Jan 12, 2009 at 9:12 AM, Ian Barwick <barwick@gmail.com> wrote:
> 2009/1/12 Phoenix Kiula <phoenix.kiula@gmail.com>:
>> I am trying to resize a column on a large-ish database (with 5 million rows).
>>
>
> ALTER TABLE users ALTER COLUMN name TYPE VARCHAR(35)
>
> HTH
>



Thanks! I guess I was missing the word "TYPE". This won't affect my
"not null" on the column right?

Also, is there a safe and fast way of doing this on a live database,
without bringing it down if possible? This is an indexed column so I
wonder if that will slow up the process quite a bit?