Skip to main content
3 of 8
added 73 characters in body
Joril
  • 441
  • 1
  • 5
  • 10

Why won't most DBMSes allow to 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