>>Use ALTER TABLE command.
>
>Thanks, this works.
>
>But, I had to remove an index as it was blocking that command. Then, I recreated the index after. Is this the normal way to do it?
Yes, in certain cases you need to re-create the index.
If it's not broken, fix it until it is.
My Blog