Simple, ROLLBACK reverts DML (data) changes, not DDL (structure)
changes..
mysql select version();
+---+
| version() |
+---+
| 4.1.7-nt |
+---+
1 row in set (0.01 sec)
mysql SHOW VARIABLES LIKE have_innodb;
+---+---+
| Variable_name | Value |
DDL cannot be rollback
http://dev.mysql.com/doc/mysql/en/cannot-roll-back.html
It also apply to many DB like Sybase for example...
Ville Karjalainen wrote:
Greetings,
I created a table during transaction and was surprised to find out it
still existed after I did a ROLLBACK. The same seems to apply