Hacker News new | ask | show | jobs
by pbz 1432 days ago
With SQL Server the management tool does give you a way to do this. Yes, it does a table rebuild behind the scenes. The point is that it's easy. Don't have experience with the other two, but MySQL is the most popular so it kinda sets the tone whether we like it or not.
1 comments
hans_castorp 1432 days 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.

link
jl6 1432 days ago
Tangential, 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.

link