How to drop a SQLite database

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 entire database is contained in one file. So there is no need for a SQLite “drop database” command, all you have to do to drop the database is to delete the SQLite database file you were accessing.

SQLite drop database command - Research

Note: I just dug around to make sure I wasn't missing anything here, and I found this comment on the SQLite website:

"DROP DATABASE" does not seem meaningful for an embedded database engine like SQLite. To create a new database, just do sqlite_open(). To drop a database, delete the file.

Add new comment

Anonymous format

  • Allowed HTML tags: <em> <strong> <cite> <code> <ul type> <ol start type> <li> <pre>
  • Lines and paragraphs break automatically.