Re: [sqlite] PRAGMA foreign_key_list(table-name);
> Le 30 mars 2017 à 11:45, Simon Slavina écrit : > >> But: >> >> PRAGMA foreign_key_list(table-name); > > Likewise. I agree that the documentation should have "schema." somewhere for > this one. After some tests, it looks like: PRAGMA schema.foreign_key_list(table-name) is indeed perfectly functional as expected. This is only a minor documentation issue. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia, http://integral.software ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] PRAGMA foreign_key_list(table-name);
> On 30 Mar 2017, at 9:59am, Olivier Masciawrote: > > PRAGMA schema.foreign_key_check(table-name); > > (with 'schema.' being optional of course) Had I not read the documentation I’d have tried PRAGMA foreign_key_check(schema.table-name); and expected it to work. > But: > > PRAGMA foreign_key_list(table-name); Likewise. I agree that the documentation should have "schema." somewhere for this one. Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] PRAGMA foreign_key_list(table-name);
Regarding https://www.sqlite.org/pragma.html#pragma_foreign_key_list: I see: PRAGMA schema.foreign_key_check(table-name); (with 'schema.' being optional of course) But: PRAGMA foreign_key_list(table-name); (no schema option apparently) Am I missing something? Or is the documentation missing some precision here? -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia, http://integral.software ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users