Quote:
Originally Posted by xXziroXx
It's a good thing to vacuum after dropping a table.
NPC Code:
DROP TABLE table_name
VACUUM
|
Actually, no it isn't, considering HD space is not vital unless Stefan says so. SQLite uses that empty space for future data, it can write to the file without having to resize it.
In SQLite if you want to drop a column you should create a backup table. If you want to drop column b in a table named spelling that has columns a, b, c, you would do:
BEGIN
CREATE TABLE spelling_bak AS SELECT a, c FROM spelling
DROP TABLE spelling
CREATE TABLE spelling AS SELECT * FROM spelling_bak
COMMIT