List foreign keys in SQLite. http://stackoverflow.com/questions/5499003/sqlite-list-all-foreign-keys-in-a-database

schema_list_fk.sql

SELECT sql
  FROM (
        SELECT sql sql, type type, tbl_name tbl_name, name name
          FROM sqlite_master
         UNION ALL
        SELECT sql, type, tbl_name, name
          FROM sqlite_temp_master
       )
 WHERE type != 'meta'
   AND sql NOTNULL
   AND name NOT LIKE 'sqlite_%'
   ANE sql LIKE '%REFERENCES%'
 ORDER BY substr(type, 2, 1), name

FYI: ANE sql LIKE '%REFERENCES%' should be AND sql LIKE '%REFERENCES%'