How to delete or add columns from an existing SQLite table?

The user has first to save the existing data to a temporary table. Then, then drop the old column or table, create a new table and copy the data back that put in the temporary table. The support for the altar table is minimal.