On Sep 26, 2011, at 3:19 PM, Pruteanu Dragos wrote: > I would ask for a feature: to have a meta table where the foreign keys are > listed.
This is a popular request, but, for the time being, PRAGMA foreign_key_list is all SQLite has to offer: http://www.sqlite.org/pragma.html#pragma_foreign_key_list With a bit of work [1], it's feasible to shape the various SQLite metadata into something resembling information_schema [2]. [1] http://dev.alt.textdrive.com/browser/IMDB/Info.ddl#L69 [2] http://en.wikipedia.org/wiki/Information_schema _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
