title: Modify a Column's Type in sqlite3
body: <p>I'm pretty new to SQLite 3 and just now I had to add a column to an existing table I had. I went about doing that by doing: <code>ALTER TABLE thetable ADD COLUMN category;</code>.</p>
  
  <p>Of course, I forgot to specify that column's type. The first thing I was thinking about doing was dropping that column and then re-adding it. However, it seems that SQLite does not have a simple way of doing this, and I would have had to backup the table and re-create it without the column.</p>
  
  <p>This seems messy, and I was wondering if there were just a way of modifying/adding a column's type. I would imagine so, but my searching around yielded no results, being new to SQLite, I imagine it was due to my wording being off in the query.</p>