> 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

Reply via email to