I think he's asking for FK constraint names to be reported in conflict messages which has been requested in the past, but not included up until now because of the approach taken.
On Sep 24, 2017 4:16 PM, "Keith Medcalf" <kmedc...@dessus.com> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
