On 30 Dec 2014, at 3:53pm, Jonathan Leslie <[email protected]> wrote:
> Sorry, I wasn't clear. what if there are other child tables, say child02- > childxx, and you don't know the names of the table, you want to search the > entire database? SQLite has no command which will help it specifically find all the child rows of a row. You will have to use a set of SELECT commands like the one Hick posted. It would be possible to write some clever code which came up with this list. You would want to start off executing PRAGMA foreign_key_list(table-name) and looking at the results you get back from it. From those you could generate SELECT statements which found the child rows. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
