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
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: