> 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
> 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
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
3 matches
Mail list logo