Skip to main content
5 of 8
edited title
RolandoMySQLDBA
  • 184.3k
  • 33
  • 323
  • 531

Why won't some DBMS's allow rollback certain DDL statements?

Recently I found out that MySQL doesn't support rollback of DDL such as "alter table"... Being used to PostgreSQL, that struck me as odd, but a friend of mine told me that even Oracle doesn't allow it.. Are there technical reasons for not supporting it? Is it simply an "uninteresting" feature for them?

Edit: just found this comparison. It looks like there are many DBMSes that do support transactional DDL.

Joril
  • 441
  • 1
  • 5
  • 10