title: PRAGMA foreign_key_check;
body: <p>I am trying to use <code>PRAGMA foreign_key_check;</code> without success :(</p>
  
  <p>I have made some foreign keys violations on a database (with <code>PRAGMA foreign_keys = OFF;</code>), then I set this to true then launched <code>PRAGMA foreign_key_check;</code> but this did not return any results.</p>
  
  <p>However, when I try to insert the very same lines with foreign keys violations with <code>PRAGMA foreign_keys = ON;</code> I do get a foreign key constraint violation error.</p>
  
  <p>I am using SQLite 3.7.3.</p>
  
  <p>Is there something I am missing regarding this command? Is there a bug?</p>
  
  <p>Thanks</p>
  
  <p>EDIT: I have just tried with 3.8.3.1 (higher version this time ;) ) but cannot get any results though :( </p>
  
  <p>However, some other commands seem to not work as expected (especially .schema !?): </p>
  
  <pre><code>SQLite version 3.8.3.1 2014-02-11 14:52:19
  Enter ".help" for instructions
  Enter SQL statements terminated with a ";"
  sqlite&gt; attach "D:\MusicLib_Minimal_TEST_FOREIGN_KEYS.db" as db1;
  sqlite&gt; .schema device
  sqlite&gt; PRAGMA foreign_keys=ON;
  sqlite&gt; PRAGMA foreign_keys;
  1
  sqlite&gt; PRAGMA foreign_key_check;
  sqlite&gt; select * from device
     ...&gt; ;
  1|test|/|/|0|0
  sqlite&gt; select * from playlist
     ...&gt; ;
  sqlite&gt; PRAGMA integrity_check;
  ok
  sqlite&gt; .dump device
  PRAGMA foreign_keys=OFF;
  BEGIN TRANSACTION;
  COMMIT;
  sqlite&gt; PRAGMA table_info(device);
  0|idDevice|INTEGER|1||1
  1|name|TEXT|1||0
  2|source|TEXT|1||0
  3|destination|TEXT|1||0
  4|idPlaylist|INTEGER|1||0
  5|idMachine|INTEGER|1||0
  sqlite&gt;
  </code></pre>