Last answered:

12 Sept 2021

Posted on:

10 Sept 2021

0

Resolved: Is it possible to undo drop table?

I tried drop table instead of delete from. It seems that rollback doesn't work to undo that. Is there a way to do that?

1 answers ( 1 marked as helpful)
Instructor
Posted on:

12 Sept 2021

0

Hi Marcus!

Thanks for reaching out.

Can you please check that you've executed a COMMIT; statement prior to using the DROP TABLE statement?
If not, it may be the right moment to refer to a back-up of your dataset.

Hope this helps.
Best,
Martin

Submit an answer