On 12 Dec 2011, at 9:26am, Roughbert Strong wrote: > Suppose that we want to know what the foreign key > constraints are on columns returned by a query. Can we obtain this > information > without parsing the query itself and looking at the PRAGMA foreign_key_list > for each table thus > discovered?
You might be able to do it using EXPLAIN or EXPLAIN QUERY PLAN but I don't think there's an ideal way. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
