SQLite database FAQ: How do I drop a SQLite database?
Solution
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.