title: SQLite - alter a table's column type?
body: <p>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.</p>
  
  <p>Regards,
  Nick</p>