CODEWITHSUNDEEP
androidsqlite
yoshi24
yoshi24

Reputation: 3177

adding a column to SQLite table in Android?

I would 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?

Upvotes: 3

Views: 5746

Answers (3)

Jonathan Hall
Jonathan Hall

Reputation: 79594

Use the ALTER TABLE command:

ALTER TABLE my_table
    ADD COLUMN new_column;

Upvotes: 10

Tocco
Tocco

Reputation: 1705

Use the alter table clause See this

Upvotes: 1

wfoster
wfoster

Reputation: 791

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

Upvotes: 5

Related Questions