SQLite Forum

Switching data between two columns
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?