drop-table Archives

How to undo DROP TABLE statement?

By adminPosted on September 8, 2023

Question : I’ve accidentally executed DROP TABLE statement on a wrong table. I have backups that are several days old […]

By adminPosted on August 25, 2023

Question : I had a table with 70+ million records in a SQL Server database, I dropped that table (a […]

By adminPosted on July 17, 2023

Question : I have a table with approx. 200 million rows (approx. 0.5 TB) and I want to drop it, […]

By adminPosted on June 5, 2023

Question : I was going to ask why mysqldump was trying to write dropped tables but I found that answer […]

By adminPosted on March 31, 2023

Question : What does the TRUNCATE do differently to drop? I believe it deletes all the data in the table […]

By adminPosted on February 23, 2023

Question : I’m trying to drop a view, of which I cannot assure whether it is a MATERIALIZED VIEW or […]

By adminPosted on January 5, 2023

Question : For a system with sensitive information stored in a PostgreSQL 9.5 database, in which data stored in a […]

By adminPosted on November 11, 2022

Question : I received this out of memory error when trying to drop a large table (70GB including index) but […]

By adminPosted on November 3, 2022

Question : I am currently looking to setup automatic failover for my MySQL 5.6.21 Master on CentOS 6.6. I have […]

By adminPosted on May 26, 2022

Question : I know it is often asking question. But I can’t find answer for my scenario with specific condition. […]