On Wed, Mar 20, 2013 at 05:57:12PM +0100, Staffan Tylen scratched on the wall: > > PRAGMA table_info(database.tablename) > > > > Any chance that SQLite4 might change this, or perhaps accept both forms ?
> In addition, how about a pragma to get the tables in a database? We > currently have pragma(database_list), pragma(index_list), and > pragma(table_info), but no pragma(table_list) - a SELECT against > sqlite_master is necessary to get hold of the table names. IMHO it's not > what one would expect. I would expect exactly the opposite. Part of the core philosophy of Relational systems is that all information, including self-inspection information, is available via tables-- specifically via the SELECT command. These are the "system catalogs" found in most DBs including Oracle, MySQL, Postgres, and many others. If there is any change I'd like to see, it is that all the PRAGMAs that return tabular data should really be system catalog tables. That way I can use WHERE on them. In the past I've used virtual tables to wrap the PRAGMAs into something that looked and acted more like a real table. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
