On 11 Sep 2015, at 12:32am, Roman Fleysher <roman.fleysher at einstein.yu.edu> wrote:
> Meanwhile, I tested if PRAGMA integrity_check checks column constraints. You > can bump up 90% of being sure it does not to 100%. It does not. Is there a > way to do it, other than export the data out and try to re-insert it? I can't think of one. I would argue that in SQLite4 (or some future version of SQLite3) "PRAGMA integrity_check" should check constraints as well as consistency. Simon.
