Why do you think this? The syntax diagrams are quite clear that FOREIGN KEY constraints can be named.
sqlite> create table parent ...> (id integer primary key); sqlite> create table child ...> (fk integer null, ...> constraint dippydoo foreign key (fk) references parent(id)); sqlite> --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Csányi Pál >Sent: Sunday, 24 September, 2017 12:06 >To: SQlite User >Subject: [sqlite] Support for named foreign keys? > >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
