Try
"select * from sqlite-master";
Regards,
[EMAIL PROTECTED]
NCCI
Boca Raton, Florida
561.893.2415
greetings / avec mes meilleures salutations / Cordialmente
mit freundlichen Grüßen / Med vänlig hälsning
"Ara.T.Howard"
<[EMAIL PROTECTED] To: sqlite
<sqlite-users@sqlite.org>
a.gov> cc:
Subject: [sqlite] determining
all tables and fieldnames in a db
04/28/2005 10:14
AM
Please respond to
sqlite-users
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
===============================================================================
The information contained in this e-mail message is intended only for
the personal and confidential use of the recipient(s) named above. This
message may be an attorney-client communication and/or work product and
as such is privileged and confidential. If the reader of this message
is not the intended recipient or an agent responsible for delivering it
to the intended recipient, you are hereby notified that you have
received this document in error and that any review, dissemination,
distribution, or copying of this message is strictly prohibited. If you
have received this communication in error, please notify us immediately
by e-mail, and delete the original message.
