adding a column to SQLite table in Android?

I wo开发者_如何转开发uld like to add another column to a table in my existing SQLite database.

Is this possible, or is there something specific I need to do to upgrade it?

If so, how do I go about doing this?

Use the ALTER TABLE command:

ALTER TABLE my_table
    ADD COLUMN new_column;

Consider using an ALTER TABLE script this guide should give you all you need, http://www.sqlite.org/lang_altertable.html

Use the alter table clause See this