> 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 index on them). Dan. > Regards. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users