adding a column to SQLite table in Android?

Question

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?

Jonathan Hall · Accepted Answer · 2011-07-08 21:33:13Z

10

Use the ALTER TABLE command:

ALTER TABLE my_table
    ADD COLUMN new_column;

answered Jul 8, 2011 at 21:33

Jonathan Hall

80.5k19 gold badges162 silver badges206 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

yoshi24 Over a year ago

Where to i implement this at? in the createDatabse method? where i initially create the database?

Jonathan Hall Over a year ago

You just execute that command in sqlite, same as any other SQL query.

Kay Gladen Over a year ago

If you extend SQLiteOpenHelper then I would recommend to use onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion).

wfoster · Accepted Answer · 2011-07-08 21:32:28Z

5

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

answered Jul 8, 2011 at 21:32

wfoster

79110 silver badges23 bronze badges

Comments

Tocco · Accepted Answer · 2011-07-08 21:33:02Z

1

Use the alter table clause See this

answered Jul 8, 2011 at 21:33

Tocco

1,71311 silver badges14 bronze badges

1 Comment

yoshi24 Over a year ago

Can you provide an example of how to implement this?

Collectives™ on Stack Overflow

adding a column to SQLite table in Android?

3 Answers 3

3 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related