How to delete the SQL Database from emulator

Question

When i deploy my app to Emulator in Android the DB will also get deployed. If i do any changes to DB it will not get deployed again to Emulator. To do this, everytime i have to delete the Emulator from device manager and create new one. This process is really annoying, any idea of how to delete the DB from Emulator and deploy new one.

smunk · Accepted Answer · 2016-04-15 16:00:21Z

2

you just need to increase the version of the data base which you provide in constructor or the class extending the SQLIteOpenHelper......

and override onUpgrade in SQLIteOpenHelper :

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  if (newVersion > oldVersion)
    Log.v("Database Upgrade", "Database version higher than old.");
  myContext.deleteDatabase(DB_NAME);
}

edited Apr 15, 2016 at 16:00

smunk

3243 silver badges8 bronze badges

answered Jun 27, 2012 at 6:06

Dheeresh Singh

15.7k3 gold badges40 silver badges36 bronze badges

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

Comments

Xenione · Accepted Answer · 2012-06-27 06:13:22Z

1

easier:

open DDMS prespective (menu windows >> open new prespective )

select file explore tag.

then go to data > data > pakage_name> databases> data_base_name.

and delete

answered Jun 27, 2012 at 6:13

Xenione

2,2131 gold badge25 silver badges31 bronze badges

Comments

Andy · Accepted Answer · 2012-06-27 06:18:40Z

1

follow these steps:

DDMS > select emulater from left side panel

from right handside choose filexplorer > choose your application package click on databse foder select your database and delete it from top right handside ("red color minus") delete button

answered Jun 27, 2012 at 6:18

Andy

5,3797 gold badges41 silver badges54 bronze badges

Comments

Jack Satriano · Accepted Answer · 2012-06-27 06:08:53Z

0

Quick and easy:

 context.deleteDatabase(DATABASE_NAME);

answered Jun 27, 2012 at 6:08

Jack Satriano

2,0291 gold badge14 silver badges17 bronze badges

Comments

Khan · Accepted Answer · 2012-06-27 06:27:03Z

0

one more way if u want to delete database just drop table and again recreate table again as shown below where

String Droptable="drop table if exists item_master"; // where item_master is table name 
myDataBase.execSQL(Droptable);

after dropping it recreate it as

 String Createtable="CREATE TABLE \"item_master\" (\"item_id\" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL  UNIQUE , \"item_name\" VARCHAR, \"item_img\" VARCHAR, \"item_s_desc\" TEXT, \"item_desc\" TEXT, \"item_map\" VARCHAR, \"bookmark\" VARCHAR DEFAULT N, \"category_id\" INTEGER)"; 

 myDataBase.execSQL(Createtable);

you can chnage column name or add or remove column according to ur requirement

answered Jun 27, 2012 at 6:27

Khan

7,6053 gold badges32 silver badges44 bronze badges

Comments

Avi Kumar · Accepted Answer · 2012-06-27 06:56:54Z

0

Rather than deleting emulator delete the database from

ddms----> file explorer ----> data/data/your_package_name--->databases --->yourdatabase .

and delete it.

and you can do one more thing

simply uninstall the application and install it again , this will remove the database and shall create the database again.

edited Jun 27, 2012 at 6:56

answered Jun 27, 2012 at 6:13

Avi Kumar

4,4299 gold badges38 silver badges67 bronze badges

Collectives™ on Stack Overflow

How to delete the SQL Database from emulator

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related