[28-04-2005 15:14, Ara.T.Howard escreveu]
is there a query that can be run against 2.8.x and 3.x dbs that will return
something like

tablename | fieldname | fieldname | fieldname

SELECT tbl_name FROM sqlite_master WHERE type='table';

to get the table list and

PRAGMA table_info(tbl_name);

to return field info for each table.

AFAIK, there is no way to do it in a single query.

Regards,
~Nuno Lucas

Reply via email to