Delete entire database with severals table in code inside sql android

Question

I've a database (BASE2.db) with 4 tables inside, but, when i want to delete the database i've an error:

the code:

db.execSQL("DROP DATABASE IF EXISTS BASE2.db");

the logcat:

(1) near "DATABASE": syntax error

I've try this, but not correct:

db.execSQL("DROP TABLE IF EXISTS BASE2.db");

How to do this?

Nermeen · Accepted Answer · 2013-03-05 08:29:44Z

2

Try to use the following:

context.deleteDatabase(databaseName.db);

answered Mar 5, 2013 at 8:29

Nermeen

16k5 gold badges62 silver badges73 bronze badges

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

1 Comment

but how to know the databsae path if the appli is moved to the sd card?

kdehairy · Accepted Answer · 2013-03-06 07:17:26Z

1

try this

this.deleteDatabase("databasename.db");

where this refers to your Activity, or any Context.

for more refer this blog

http://logcatsolutions.blogspot.in/2012/07/sqlite-complete-example-create.html

kdehairy

2,7301 gold badge22 silver badges29 bronze badges

answered Mar 5, 2013 at 10:25

jithu

7061 gold badge9 silver badges13 bronze badges