On 12/12/10 00:29, Darren Duncan wrote: > Petite Abeille wrote: >> On Dec 11, 2010, at 3:48 PM, Simon Slavin wrote: >> >>> Section 21 of the (SQL92) standard. >> Yes, the notorious information schema: > Nonsense. An information schema is a *good* thing, and is generally the > *best* > tool for introspecting a database. It lets you use all the power features > you > have when querying data, anything a SELECT can do, and you can query the > database structure likewise. This is the way a relational database is > supposed > to work. -- Darren Duncan > _______________________________________________ Okay, I'm not describing a relational database ...
But one of the very nice features of Pick is it is self-describing. The top level is a pick "table" called MD. This is described by a Pick "table" called the dictionary. Everything in Pick is a FILE (the Pick name for a table), from the top down. Even indices. Dunno how well that approach translates into a relational engine, because Pick has several very non-relational quirks (every "row" MUST have a primary key, the dictionary DEscribes, not PREscribes the FILE, etc etc). But it means you can use your standard query tools to query EVERYTHING. Cheers, Wol _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
