On 4/4/16, Domingo Alvarez Duarte <sqlite-mail at dev.dadbiz.es> wrote: > sqlite knows which table/field failed
No it doesn't, actually. SQLite keeps a counter of FK violations and resolutions, and if that counter is zero at the the end of the transaction, then it knows that no FK constraints have failed. If the counter is non-zero, then it knows that one or more FK constraints have failed, but it has no idea which ones. -- D. Richard Hipp drh at sqlite.org
