On Nov 12, 2010, at 7:20 AM, Roger Binns wrote: >> A ticket that has been open on this topic since January 2006. > > Oops, forgot to paste: > > http://www.sqlite.org/src/tktview?name=23b2128201
Thanks for that. Since 2006? High priority indeed :) That said, maybe SQLite has reached a point where it would benefit from a proper data dictionary of sort, perhaps something along the lines of ANSI ISO 9075 Information Schema and Definition Schema (aka INFORMATION_SCHEMA) [1] or such . Something a bit more full fledged than the one on the wiki though [2] :) Right now, there are bits and pieces here and there: pragma database_list ~= information_schema.schemata sqlite_[temp_]master ~= information_schema.tables pragma table_info ~= information_schema.columns pragma foreign_key_list ~= information_schema.referential_constraints/key_column_usage Other pieces of information could be inferred from pragma index_list/index_info. And that's about it at first glance. But altogether, nothing really comprehensive, nor very accessible (i.e. multitude of non queryable pragmas or raw DDL). Has anyone attempted to outfit SQLite with a proper data dictionary? [1] http://en.wikipedia.org/wiki/Information_schema [2] http://www.sqlite.org/cvstrac/wiki?p=InformationSchema _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
