An added column has a name, type and optional default. Existing rows receive the default, so a column that does not allow NULL must have one. SQLite does not allow an added column to be a primary key, to be unique, or to default to the current time or date. Rebuild the table with SQL to make those changes.

Renaming changes only the name. SQLite also updates dependent indexes, triggers and views. It rejects the rename if the updated schema would be ambiguous or invalid.

Changing a column's type, NULL rule, default or key requires rebuilding the table. Use Execute SQL if your module permissions allow it.