how to drop database in sqlite

Question

I m using SQLite in android  I want to drop the database   For example  mysql- drop database dbname  How do I implement this code in SQLite

User · Accepted Answer

The concept of creating or dropping a database is not meaningful for an embedded database engine like SQLite. It only has meaning with a client-sever database system, such as used by MySQL or Postgres.

To create a new database, just do sqlite_open() or from the command line sqlite3 databasefilename.

To drop a database, delete the file.

Reference: sqlite - Unsupported SQL

User · Answer

to delete your app database try this    this deleteDatabase  databasename db      this will delete the database file

User · Answer

try this     context deleteDatabase DATABASE NAME     How to delete SQLite database from Android programmatically

User · Answer

If you use SQLiteOpenHelper you can do this          String myPath   DB PATH   DB NAME          SQLiteDatabase deleteDatabase new File myPath

User · Answer

If you want to delete database programatically you can use deleteDatabase from Context class      deleteDatabase String name    Delete an existing private SQLiteDatabase associated with this Context s application package

User · Answer

From http   www sqlite org cvstrac wiki p UnsupportedSql     To create a new database  just do   sqlite open    To drop a database    delete the file

User · Answer

You can drop tables by issuing an SQL Command as you would normally  If you want to drop the whole database you ll have to delete the file  You can delete the file located under   data data com your app name database  databasefilename   you can do this from the eclipse view called  FileBrowser  out of the  Android  Category for example  Or directly on your emulator or phone

User · Answer

SQLite database FAQ  How do I drop a SQLite database   People used to working with other databases are used to having a  drop database  command  but in SQLite there is no similar command  The reason  In SQLite there is no  database server  -- SQLite is an embedded database  and your database is entirely contained in one file  So there is no need for a SQLite drop database command   To  drop  a SQLite database  all you have to do is delete the SQLite database file you were accessing    copy from http   alvinalexander com android sqlite-drop-database-how

[android] how to drop database in sqlite?

Examples related to android

Examples related to sqlite