SQLite Delete (Drop) Database

Here we will learn how to delete or drop a database in SQLite with example.

SQLite Drop Database

Like most relational database systems, SQLite does not use the DROP DATABASE command to drop a database and there is no special syntax or steps to drop the database in SQLite. You just have to delete the file manually

 

Here filename is always unique i.e. database name is always unique and it is case-sensitive. SQLite stores the whole database in a single disk file so if you want to delete the database then manually go that file location and delete it.

 

SQLite Delete Database from Folder Manually

 

Here it is important to note that be careful before deleting the database because deleting an existing database would result in loss of complete information stored in the database.