Re: DDL and DML in a transaction

Thank you, David. I should get more sleep... Igal On 7/31/2019 11:52 AM, David G. Johnston wrote: On Wed, Jul 31, 2019 at 11:38 AM Igal @ Lucee.org > wrote:      alter table some_table     rename column amount_num to amount_text; alter table some

Re: DDL and DML in a transaction

On Wed, Jul 31, 2019 at 11:38 AM Igal @ 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 su

DDL and DML in a transaction

I am trying to change a text column into a numeric one in a large table. My idea was to add a new column, update it, drop the old column, and rename the new one to the old name.  I am hoping that that would make it faster and minimize locking time though I'm not sure that it would. I am there