On 4 Jun 2010, at 3:25am, Wincent wrote:

> After the DROP, a CREATE TABLE command is executed to create a table
> with the same name as structure.

Then some of the file which contained data from the old TABLE has probably 
already been overwritten.  It may be that some data is already irretrievable.  
The more you do to that database file, the more chance you have of overwriting 
data that used to be in that TABLE.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to