[sqlite] determining all tables and fieldnames in a db

[Ara.T.Howard]

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

for example given

  create table foo (
    a,
    b
  );

  create table bar (
    x,
    y,
    z
  );

this should return

  foo|a|b|NULL
  bar|x|y|z

another alternative would be to have two queries, one returning

  foo
  bar

and another returning

  a|b

and

  x|y|z

for foo and bar respectively (iterate querying for each table returned from
first query)

i need to do this via the api NOT the sqlite commandline interface.

kind regards.

-a
--
===============================================================================
| email   :: ara [dot] t [dot] howard [at] noaa [dot] gov
| phone   :: 303.497.6469
| although gold dust is precious, when it gets in your eyes, it obstructs
| your vision. --hsi-tang
===============================================================================