On Tue, Aug 02, 2011 at 12:03:52 +0100, Jack Hughes wrote:
> Any ideas how I can remove unused fields from the database would be
> appreciated.
I'd consider creating the new database from scratch and importing the data
from the old one (by attaching it and doing insert ... select). That way
you'd only have one code for creating the schema and it would have
side-effect of defragmenting the database. It would of course take longer,
though.
--
Jan 'Bulb' Hudec <b...@ucw.cz>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
