On Wed, Jul 31, 2019 at 11:38 AM Igal @ Lucee.org <i...@lucee.org> wrote:

>      alter table some_table
>          rename column amount_num to amount_text;
>
>      alter table some_table
>          drop column amount_num;
>

You just renamed amount_num to amount_text so I'm not sure why you expect
the drop to succeed.

Would it have less locking than simply altering the column?
>

I doubt anything will improve upon simply altering the column.  You have to
perform a full table rewrite in either case which is going to be the main
resource consumer.

David J.

Reply via email to