<horrified expression> You're altering tables you don't understand the structure of? </horrified expression>
You missed his point. When you use the steps in the FAQ to alter a table, one of the steps involves deleting it. When you do that SQLite also deletes all existing triggers and indices on the table.
Consequently one piece of code that is simple (alter table) suddenly has to be aware of a lot more other things. It
is all a simple matter of programming, but makes the code
more coupled, complex and brittle.
Roger
