Hi! I've read a lot of discussion about the constraints related to why SQLite doesn't have destructive column commands (MODIFY, RENAME, DROP, etc.). Despite that, we still have situations where our data model changes, and a column becomes obsolete. Given the constraints, we've decided to create a column "graveyard" at the application level: basically a list of columns that exist but are obsolete. While we cannot drop columns, we would like to make sure that the space occupied by the columns contents is zeroed and returned to SQLite's free list (https://www.sqlite.org/faq.html#q12) to be re-used. Is setting the column's contents to "" (for a TEXT column specifically) sufficient to do that?
Thanks! Ben _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
