Marcus Wern Han Leong
Last answered:

12 Sept 2021

 Posted on:

10 Sept 2021
0

Resolved: Is it possible to undo drop table?

in SQL / The DELETE Statement - Part II

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)
Martin Ganchev
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

Helpful answer

Submit an answer

related questions

Sivarajan Sivakumar
0
18
Cannot insert 999903 into the dept_emp table?
Harsha Dharmabandu
1
14
Resolved: foreign key : able to see foreign key in the table sales DDL tab , but the Foreign Keys tab is empty
Michele Cannito Buch
0
14
Resolved: DROP FOREIGN KEY sales_ibfk_1 -- huh?
lalit yadav
7
12
Resolved: M query fetch time increased after creating an index for the salaries table!
Snoor Salihi
0
10
Resolved: Drop table from the database
Ashakah Onome Andrew
0
10
Resolved: Salaries table is empty, showing Null
Francois Chouinard
1
10
Can you show the instructions to reproduce dept_manager_dup table?
Matt Birch
0
10
Error after Error: Can't create a table this time
Longyin Li
0
8
cant't create table in sql
Abdul Rehman
0
6
Resolved: Why you are using different query editor for like new query for table creation of sales then new que
Pawee Chiranothai
0
6
Why does drawing data from dept_manager_dup table get different results?
Geetanjali Juneja Upadhyay
0
6
15. sql subquires--Can you please help to find out why in the video you are using the dept_emp table