On Fri, 07 Jun 2019 01:43:18 -0600
"Keith Medcalf" 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
Improved version that does not execute the eval multiple times. I have not
renamed the columns match the ANSI INFORMATION_SCHEMA views, though I suppose
that might be possible (though I find that schema yucky -- it embodies the
thinking from decades ago where one would embed table names into c
-schema.html
Regards
-Original Message-
From: Keith Medcalf
To: SQLite Users (sqlite-users@mailinglists.sqlite.org)
Sent: Thu, Jun 6, 2019 1:55 pm
Subject: [sqlite] New Information Schema Views
This is an update to the Schema Information views that I previously posted.
This version has
This is an update to the Schema Information views that I previously posted.
This version has the capability to display information for all available schema
names (attached databases) simultaneously. It requires that the SQL function
"eval" be available since it runs dynamically generated SQL
4 matches
Mail list logo