Some freeware SQLite tools, such as SQLiteStudio, allow you to drop columns (they do it by copying the table, but it's transparent to you). If you don't need to drop the column programmatically, as part of a bigger automated process, it works and you don't have to code anything.
gs _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users