3 ms·
The problem here is specifically with how SQLite does not implement ALTER TABLE fully. From the documentation: "SQLite supports a limited subset of ALTER TABLE
by jsherer 15y ago
The problem here is specifically with how SQLite does not implement ALTER TABLE fully. From the documentation:
"SQLite supports a limited subset of ALTER TABLE. The ALTER TABLE command in SQLite allows the user to rename a table or to add a new column to an existing table. It is not possible to rename a column, remove a column, or add or remove constraints from a table."
http://www.sqlite.org/lang_altertable.html http://www.sqlite.org/lang_altertable.html
- StavrosK 15y agoAh, too bad, I was thinking how this could be done with one table. It sounds like it would be too much of a hassle, as it would keep growing. I don't think it's too much of a problem to have different tables, though, most people would have single indexes, I guess.