> On Aug 15, 2018, at 11:55 AM, R Smith <ryansmit...@gmail.com> wrote: > > This has been existing for quite a while in SQLite, and not only this, but > quite a few schema enumeration functions via the table-valued-function form > of the pragmas.
FWIW, information_schema would be the relevant ANSI-standard in that matter: https://en.wikipedia.org/wiki/Information_schema The following data dictionaries can be implemented in a pretty straightforward way in sqlite: information_schema.catalog_name information_schema.schemata information_schema.tables information_schema.columns information_schema.table_constraints information_schema.referential_constraints information_schema.key_column_usage YMMV. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users