Re:SQLite cannot drop columns
by MarkR42 on Monday September 16, 2013 @05:45PM
(#6396114)
Essentially, ALTER TABLE ... DROP COLUMN is just syntactic sugar, you can do the operation equally efficiently (albeit with more complexity) with other statements.
In any case, sqlite CAN at least drop indexes, which is something that some versions of MySQL did quite badly (without a table rebuild)
In any case, sqlite CAN at least drop indexes, which is something that some versions of MySQL did quite badly (without a table rebuild)