SQLite Forum

Switching data between two columns
Login
Can depend on how all the code is written for the inserts and for selects from the table. You're effectively re-ordering the columns. So if every single bit of inserting code explicitly calls out the field names: "insert into t (ProjID, c1, c2, c3, c4, c5, InsertDate) values (?,?,?,?,?,?,?);" then it might be ok. If anywhere uses "insert into t values (?,?,?,?,?,?,?);" without the column names, then you've just messed things up again or need to go through every last bit of code again. Plus checking for anywhere you did "select * from" and just assumed "I designed the table, c3 is the 4th thing and c4 is the 5th and it will stay that way." because all those assumptions would now be wrong.