On Tue, 2007-02-27 at 10:48 +0100, Michael Schlenker wrote: > Hi all, > > for some uses its nice to query the PRAGMA and the sqlite_master table > with a single query instead of multiple PRAGMA statements. > > Could the Pragmas to query the database schema be converted to virtual > tables? (that would enable joins with sqlite_master and other nice uses > to get all schema info for a table with a single statement). > > Or did some already do something like that?
There is some code for an sqlite extension in the src/test_schema.c of the distribution that provides a read-only view of the database schema as a virtual table. Dan. > Michael > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------