The sqlite_master table should have this information. SELECT count() FROM sqlite_master WHERE name IS your_constraint_name AND tbl_name IS your_table_name;
On July 3, 2017 9:37:04 AM EDT, Igor Korot <ikoro...@gmail.com> wrote: >Hi, Keith et al, > >On Mon, Jul 3, 2017 at 7:13 AM, Keith Medcalf <kmedc...@dessus.com> >wrote: >> >> From what I can tell the answer is (A). The constraint_name is >simply a comment to be reported (if possible) when the constraint is >violated. > >So is it possible to check that the foreign key with the given name >already present for a given >table? > >Thank you. > >> >> -- >> ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı >> >>> -----Original Message----- >>> From: sqlite-users >[mailto:sqlite-users-boun...@mailinglists.sqlite.org] >>> On Behalf Of Simon Slavin >>> Sent: Monday, 3 July, 2017 04:49 >>> To: SQLite mailing list >>> Subject: Re: [sqlite] FOREING KEY constraint >>> >>> >>> >>> On 3 Jul 2017, at 4:37am, Keith Medcalf <kmedc...@dessus.com> wrote: >>> >>> > What do you mean "check for uniqueness? >>> >>> If you give two constraints the same name, does SQLite >>> >>> A) Ignore the problem >>> B) Reject the second one complaining "duplicate name" >>> C) Replace the first one with the second >>> >>> Simon. >>> _______________________________________________ >>> 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 -- Sent from my Android device with K-9 Mail. Please excuse my brevity. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
