On 19 Aug 2014, at 11:41am, Jonathan Moules
<jonathanmou...@warwickshire.gov.uk> wrote:
> There are some foreign keys.
Put all your DROP TABLE commands into one big transaction.
Make sure when you DROP your TABLES that you are dropping them in an order
which won't trigger any foreign key checks. Normally this just means you have
to drop the offspring tables first.
Alternatively do
PRAGMA foreign_keys = OFF
BEGIN TRANSACTION
DROP table a
DROP table b
...
END TRANSACTION
PRAGMA foreign_keys = ON
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
