I am starting a project involving a small database and I am considering to use SQLite. If I create a table and I defined one of the columns as text, but all the values stored are integers - is there a way to change the data type of a column? I am using SQLite Manager and I can't find a function that allows me to do that. Can I do it using a SQL command, or is it a restriction of SQLite? Probably, even with this restriction, one can find some way around and create a new table with the required column types and then import data into it.
Regards, Nick
alter tableto change column type in SqLite sqlite.org/lang_altertable.html. What you can do is rename the table, create a new table with new structure and copy data to the new one. - bansi