On Dec 12, 2010, at 1:29 AM, Darren Duncan 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.
Fully agree :) "Notorious" was referring to Simon's "absolutely horrible" qualification of Section 21 of the SQL92 standard, which describes information_schema. This was a weak attempt to humor Simon :)) All in all, I'm all for a pragmatic implementation of Section 21 in SQLite. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
