To alter a table in SQLite, you use the ALTER TABLE statement. This statement allows you to add, remove, or modify columns in an existing table.

SQLite supports a limited subset of ALTER TABLE. The ALTER TABLE command in SQLite allows these alterations of an existing table. When adding a column with a CHECK constraint, or a NOT NULL constraint ...