How to reset SqLite database in Android?

android sqlite android-sqlite
Roland picture Roland · Jan 30, 2014 · Viewed 42.3k times · Source

I want my users to be able to reset the application, then I need to reset the SQLite database that I have created. How can I do that? I want to reset the database or delete and recreate the database.

Answer

Linga picture Linga · Jan 30, 2014

Just delete your database by

context.deleteDatabase(DATABASE_NAME);

Please make sure to close your database before deleting.

Related questions

How to perform an SQLite query within an Android application?

I am trying to use this query upon my Android database, but it does not return any data. Am I missing something? SQLiteDatabase db = mDbHelper.getReadableDatabase(); String select = "Select _id, title, title_raw from search Where(title_raw like " + "'%…

Read More
Set default value of an integer column SQLite

I am creating an SQLite database in android. db.execSQL("CREATE TABLE " + DATABASE_TABLE + " (" + KEY_ROWID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + KEY_NAME + " TEXT NOT NULL, " + KEY_WORKED + " INTEGER, " + KEY_NOTE + " INTEGER);"); Is it possible to set the default value of …

Read More
When is SQLiteOpenHelper onCreate() / onUpgrade() run?

I have created my tables in my SQLiteOpenHelper onCreate() but receive SQLiteException: no such table or SQLiteException: no such column errors. Why? NOTE: (This is the amalgamated summary of tens of similar questions every week. Attempting to provide a "canonical" …

Read More