On 12/18/17, Dinu <dinumar...@gmail.com> wrote: > Rowan Worth-2 wrote >> The entire point of SQL transactions is to implement this magic! > > I beg to differ; you proposed: >> (1) BEGIN TRANSACTION >> > (2) DROP all indexes from the table > This is by no means valid SQL semantics; in all RDBBMS I've worked with, > structure changes' relation to a transaction is undefined at best.
DROP, CREATE, and ALTER are transactional in SQLite, just like DELETE, INSERT, and UPDATE. This has always been the case, and always shall be. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users