4 ms·
Well, writing a procedure that rebuilds the complete table in Postgres or Oracle is easy as well. I never needed this, but I am sure, there are some sample impl
by hans_castorp 4y ago
Well, writing a procedure that rebuilds the complete table in Postgres or Oracle is easy as well. I never needed this, but I am sure, there are some sample implementations out there.
Rebuilding the entire table doesn't seem feasible for large tables to begin with. Especially with a lot of incoming and outgoing foreign keys.
I disagree that MySQL is the most "popular".
It might be the "most used" one because of so many web hosting services included it for ages by default.
- jl6 4y agoTangential, but there are almost certainly more SQLite databases in existence than every other RDBMS put together, probably by 3 or 4 orders of magnitude. It doesn’t support column reordering either.