In Android SQLite, I had one table MyTable. By mistake, I reset it after updating the database.
MyTable
How can I draw a ROLL BACK to reset the table, if possible.
Any good answer will be accepted.
Thank.
Dropping tables is not a recoverable action.
From the SQLite documentation :
The DROP TABLE statement deletes a table added using the CREATE TABLE statement. The specified name is the name of the table.The dropped table has been completely removed from the database schema and disk file. The table cannot be restored. All indexes and triggers associated with the table are also deleted.
The DROP TABLE statement deletes a table added using the CREATE TABLE statement. The specified name is the name of the table.
The dropped table has been completely removed from the database schema and disk file. The table cannot be restored. All indexes and triggers associated with the table are also deleted.
, (, , ).
, .
DML, "" "" ( ).
, DDL, "alter table" "drop table".
:
http://sqlite.org/lang_droptable.htmlDROP TABLE , CREATE TABLE . - . . . , .
DROP TABLE , CREATE TABLE . - . . . , .
PS:
"DDL", "DML" , :