SQLite Forum

Switching data between two columns
Login
Not to mention of course that any indexes, triggers, views, etc.  Will "follow the data" not "follow the name" -- unless of course you set old fashioned mode first. (to obtain legacy alter table operation).