Oops I left out the insert: > begin immediate; > create temp table "My Table Backup" as select * from "My Table"; > drop table "My Table"; > create table "My Table"( <new definition here with foreign key removed> );
insert into "My Table" select * from "My Table Backup"; drop table "My Table Backup"; > create trigger <any existing triggers>; > create index <any existing indexes>; > commit or rollback; <rollback if any errors above, since SQLite doesn't> Thanks, Tom BareFeetWare -- Comparison of SQLite GUI tools: http://www.barefeetware.com/sqlite/compare/?ml _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
