Question: I want recover deleted record and dropped data from SQLite db file,

I check my db file with text editor and i saw dropped data is still there..

I'm using `SQLite3.dll (in c#)` but i can`t find something property for open db with dropped data or ...

Is there any library for helping me? or something simple code for recovering data from sqlite db file?

**Edit 1:**

i try to find a data recovery library or program for sqlite.. after many searchs i found <http://www.devart.com/dotconnect/sqlite/docs/Devart.Data.SQLite~Devart.Data.SQLite.SQLiteDump.html>

```
SQLiteConnection.Open(); 
SQLiteDump sqSqlDump = new SQLiteDump(); 
sqSqlDump.Connection = SQLiteConnection1; 
sqSqlDump.IncludeDrop = true;                          //<<-- check here
sqSqlDump.Backup(); 
StreamWriter stream = new StreamWriter("d:\\dump.dmp"); 
stream.WriteLine(sqSqlDump.DumpText); 
stream.Close(); 

```

that i can use `IncludeDrop` property for backing data to me but this library is not free and i cant use it.. i like to find free library or program...

Answer: 
It is possible, at least partially, by hiring a (very expensive) data recovery firm which would recover the data by analysing the binary file. You will probably not be able to do it yourself because, as others have said, "SQLite deletes data permanently when you delete records" and that is true, because the data deletion operation in SQLite involves overwriting the metadata in the file describing where the data is and how it is related to other data.

Parts of the data might still physically be in the file but:

* The pointers to this data (sqlite uses btrees) are gone and the file regions are marked as "free space" in the metedata
* In the process of using the database, some of that space may have been overwritten and now contains garbage.

If you have have nothing to do for the next couple of months, you may start by analysing the SQLite file structure and applying that knowledge to try guessing where the data *might* have ended up in the file before it was deleted (meaning, its metadata was overwritten) and so perform the recovery. You need to start here: <http://www.sqlite.org/fileformat.html> .
I don't think that is possible, see [Documentation](http://www.sqlite.org/lang_droptable.html). I don't know what data you are seeing in your text editor.