From: Rik Wasmus Date: December 2 2011 3:16pm Subject: Re: Question about deleting data and the undo log List-Archive: http://lists.mysql.com/mysql/226429 Message-Id: <201112021616.56808.rik@grib.nl> MIME-Version: 1.0 Content-Type: Text/Plain; charset="us-ascii" Content-Transfer-Encoding: 7bit > Does "drop table" use the undo log (rollback segment) to temporarily store > records to be purged later, the way "delete from table" does? As 'DROP TABLE' causes an implicit commit (http://dev.mysql.com/doc/refman/5.5/en/implicit-commit.html), I would highly suspect that it doesnt. You cannot roll it back... -- Rik Wasmus