I took it to mean that he wants: SELECT sql FROM sqlite_master WHERE type='table';
But I could be wrong. -----Original Message----- From: Kiel W. [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 8:52 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] My first post, a few wishes.. On 7/7/05, Edwin Knoppert <[EMAIL PROTECTED]> wrote: > > 1) I wish for a better way to recreate a table's definition. > The FAQ example is no good if you are unknown to it's fields. > For example, imy dbms obtains the create table query for the user, he > might want to reset table name as add or remove fields. > After that the copy as suggested in the FAQ does not know what fields > to use. SELECT name FROM sqlite_master WHERE type='table' ORDER BY name; Is this what you are after? This is (9) of the FAQ. > See also #2 > > 2) Empty table does not return fields. > After i create a table + fields, there seems to be no way to enumerate > the fieldnames if there isn't any data inserted. > Both cols and rows return 0. > I'm using sqlite3_get_table() > I heard before to make use of prepare but i can't figure out how. > > 3) May i suggest a better (easier) forum for sqlite? > I can setup a forum independant of my own sites. > No commercials etc.. > > > -- Kiel W. [EMAIL PROTECTED] ---------------------------------- >> time is swift <<