On Fri, 07 Jun 2019 01:43:18 -0600 "Keith Medcalf" <[email protected]> wrote:
> -- Catalog Views using sqlite_master for SysObjects (Object Names) > -- requires that the eval() extension function be loaded and available > -- all TEXT columns in views have "collate nocase" attachmented to > the output > -- columns to ensure that where conditions on retrievals are not case > sensitive > -- Column Names in views defined so as to not conflict with keywords > to ensure > -- quoting when using the views is not required > -- table/view/index name MUST NOT contain embeded semicolons (;) I would like to play Omniscient Narrator for a moment and mention to our listening radio audience that this is not the first substantial contribution by the inimitable Mr. Medcalf. The other one that I remember was a complete set of functions for math.h. I'm sure there are others. For users coming to SQLite and knowledgable about SQL standards, INFORMATION_SCHEMA is the obvious place to look for schema metadata, much easier to query and remember than a variety of functions and pragmas and whatnot. It's not beautiful, but then very little about SQL is beautiful. What's important is that is works and is understandable and standard. Thanks, Keith. You just saved a lot of people a lot of work. --jkl _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
