Would this be a viable option when the table contains a lot of data? >alter table t rename c3 to cx;alter table t rename c4 to c3; alter table t rename cx to c4; Is there a shorter (without using the intermediate name cx) syntax?
Would this be a viable option when the table contains a lot of data? >alter table t rename c3 to cx;alter table t rename c4 to c3; alter table t rename cx to c4; Is there a shorter (without using the intermediate name cx) syntax?