Monday, October 7, 2019

How to Delete (Drop) Database in SQLite? Explain with example.

SQLite Drop Database

Like most relational database systems, SQLite does not use 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 file name is always unique i.e. database name is always unique and it is case-sensitive. As SQLite stores the whole database in single disk file so if you want to delete 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 by deleting an existing database would result in loss of complete information stored in the database.

No comments:

Post a Comment

Lab 09: Publish and subscribe to Event Grid events

  Microsoft Azure user interface Given the dynamic nature of Microsoft cloud tools, you might experience Azure UI changes that occur after t...