SQLite's ALTER TABLE command supports renaming tables and columns, adding columns, and dropping columns. The command works by modifying the schema text stored in the sqlite_schema table rather than parsed system tables. For complex schema changes not directly supported, a 12-step procedure involves creating a new table with the
•11m read time• From sqlite.org
Table of contents
1. Overview2. ALTER TABLE RENAME3. ALTER TABLE RENAME COLUMN4. ALTER TABLE ADD COLUMN5. ALTER TABLE DROP COLUMN6. Disable Error Checking Using PRAGMA writable_schema=ON7. Making Other Kinds Of Table Schema Changes8. Why ALTER TABLE is such a problem for SQLiteSort: