On Thu, 23 Mar 2017 11:56:00 +0000 Simon Slavin <slav...@bigfraud.org> wrote:
> > This problem and other related with the lack of a "data dictionary" > > in sqlite, > > Not sure what you expect here. Can you point me at a "data > dictionary" for some other implementation of SQL ? https://www.postgresql.org/docs/9.1/static/catalogs-overview.html Every commonly used DBMS has some support for system tables. ANSI standardized them with INFORMATION_SCHEMA. SQLite's support for them is notably sparse. A data dictionary commonly means something about data semantics: some description about where the data came from and what they mean. Unfortunately most system table implementations cannot be extended in that way by the user. (Of course, it is possible to write queries that refer to them. It is not possible to create constraints on system tables that e.g. require a semantic description or even just a primary key). --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users