How can we drop a database in android?

Question

Try this.

skywa1ker
– skywa1ker

2011-03-08 11:03:21 +00:00
Commented Mar 8, 2011 at 11:03 — skywa1ker
– skywa1ker, Commented Mar 8, 2011 at 11:03

Mat · Accepted Answer · 2012-08-04 10:40:36Z

2

This should work:

private SQLiteDatabase db;
private static final String TABLE_NAME = "name_of_table";

try {
  db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
  db.execSQL("VACUUM");
} catch (SQLException sqle) {....}

edited Aug 4, 2012 at 10:40

Mat

208k41 gold badges407 silver badges423 bronze badges

answered Mar 8, 2011 at 11:09

user604243

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

Comments

Mike Mackintosh · Accepted Answer · 2012-09-19 01:41:14Z

2

This is going to be a very late reply to this post, but if anyone else is facing the same issue, can try the following.

myContext.deleteDatabase(DB_NAME);

edited Sep 19, 2012 at 1:41

Mike Mackintosh

14.3k7 gold badges64 silver badges87 bronze badges

answered Sep 19, 2012 at 1:15

Avishek

811 silver badge2 bronze badges

Collectives™ on Stack Overflow

How can we drop a database in android?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related