Definitely what Clemens said: https://www.sqlite.org/syntax/table-constraint.html
But you probably want to see all the FK's, not merely named ones. I suggest parsing for the 'REFERENCES' keyword of the table schemas stored in sqlite_master (or .schema report of the shell tool). You can fix the SQLite "driver" of SchemaCrawler yourself, since it is open source. SchemaCrawler claims to already use regular expressions to parse well formed SQL schema: https://github.com/sualeh/SchemaCrawler SQLite FK including anonymous ones follows the syntax "REFERENCES foreign-table". See https://www.sqlite.org/syntax/foreign-key-clause.html On Sun, Sep 24, 2017 at 11:05 AM, Csányi Pál <csanyi...@gmail.com> wrote: > Hi, > > when will SQLite support the named foreign keys? > > I am using SchemaCrawler to visualize my SQLite databases and because > SQLite does not support it yet, foreign keys get automatically > generated foreign key names in the diagram. > > So it would be nice if SQLite would support it one day. Is'n it? > > -- > Best, Pali > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
