3 ms·
FYI: SQLite doesn't have ALTER TABLE.
by captain_perl 8y ago
FYI: SQLite doesn't have ALTER TABLE.
- coldacid 8y agoAnd this pisses me off every time a schema change needs to be made in mobile apps I develop.
- coleifer 8y agoRename table, create new/modified schema, insert into...select from old.
- deleted 8y ago[deleted]
- tim333 8y agowell, "SQLite supports a limited subset of ALTER TABLE" https://www.sqlite.org/lang_altertable.html https://www.sqlite.org/lang_altertable.html