> due serious changes in the table layout of an existing database, I need > to remove a foreign key. I could not find any SQL command in the docs, > how to do that. But this must be possibe, since SQLiteExpert supports > this. Could someone give me a hint?
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> ); 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
