After using ALTER TABLE to add column to table I was unable to open the db under Windows using many SQLite editors or browsers. Seems the problem is with the SQLite ver. that they support.
Is there tool that can open db that was modified with ALTER TABLE?
Yes,
I found after 2hrs search the tool - SQLiteSpy (free - read the License)
Links: http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index http://download.cnet.com/SQLiteSpy/3000-2065_4-75451503.html