Just run this query: "SELECT * FROM SQLITE_MASTER WHERE type='table'" This should give you all the tables in the database, their CREATE queries and some other details i don't remember at the moment
On Tue, 23 Nov 2004 11:33:36 -0800 (PST), daniel civello <[EMAIL PROTECTED]> wrote: > Hi all -- I'm having trouble understanding how to get a list of tables and > the column > names that are in a database. > > I've successfully attached a database via the sqlite command line, and I know > a few > queries which run against the database successfully, so I know it's set up > correctly. > Now, how do I get a list of the tables and columns? I'm basically wondering > if there's a > 'show tables' or 'desc <table>' command like in mysql. > > thanks! > -daniel >
