How to undo DROP TABLE statement without backup in SQL?

Question

This is impossible to answer without knowing what RDBMS (MySQL, Oracle, DB2 etc.) you are using. — Ben, Jan 04 '15 at 10:24
Which DBMS are you using? Did you already commit the drop? If not, you can rollback it in some DBMS. — , Jan 04 '15 at 11:02

score 1 · Answer 1 · edited Jan 04 '15 at 10:40

If you are using Oracle then you can use flashback drop. For more details check this link http://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr004.htm

SQL> drop table mytab;

Table dropped.

SQL> select original_name from dba_recyclebin;

Original Name
-------------------------------- 
MYTAB 

SQL> flashback table MYTAB to before drop;

Flashback complete.

SQL> select * from mytab;

ID 
---------- 
2 
2

How to undo DROP TABLE statement without backup in SQL?

1 Answers1