> And now I'd like to check that, for all foreign keys, there is an
> associated index.
> Is it feasible?
IIRC, it's tricky. In function populateTempTable(), there is code that
checks that all parent keys are either the PRIMARY KEY of their table
or subject to a UNIQUE constraint (have a UNIQUE
Hello,
I discovered the great 'genfkey' tool with the last release (3.6.4).
And I tried to customize it such as the output is not "CREATE TRIGGER"
statements but
"SELECT" statements.
Indeed, my SQLite database is populated from a MySQL dump and is not modified
afterwards.
The order of record inse
2 matches
Mail list logo