Re: [sqlite] PRAGMA foreign_key_list(table-name);

2017-03-30 Thread Olivier Mascia
> Le 30 mars 2017 à 11:45, Simon Slavin a é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 i

Re: [sqlite] PRAGMA foreign_key_list(table-name);

2017-03-30 Thread Simon Slavin
> On 30 Mar 2017, at 9:59am, Olivier Mascia wrote: > > 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: > > PRA

[sqlite] PRAGMA foreign_key_list(table-name);

2017-03-30 Thread Olivier Mascia
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 docume