I don't think so. The question is about interpreting the schema, not about executing anything at all.
--- 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 Scott Robison >Sent: Sunday, 24 September, 2017 16:47 >To: SQLite mailing list >Subject: Re: [sqlite] Support for named foreign keys? > >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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
