pragma foreign_key_list(table_name) may help
Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 3 July 2017 at 15:05, Keith Medcalf <[email protected]> wrote: > > You can get foreign key constraints with a pragma. > Check constraints need to parse the SQL. > > > -- > ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı > > > > -----Original Message----- > > From: sqlite-users [mailto:[email protected]] > > On Behalf Of Clemens Ladisch > > Sent: Monday, 3 July, 2017 08:00 > > To: [email protected] > > Subject: Re: [sqlite] FOREING KEY constraint > > > > J. King wrote: > > > 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; > > > > Constraints do not have separate entries in the sqlite_master table. > > And there is no other mechanism to get this information without parsing > > the SQL. > > > > > > Regards, > > Clemens > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
