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.