SELECT * FROM SQLITE_MASTER WHERE type = 'table' There's an explanation of the SQLITE_MASTER table at http://sqlite.org/faq.html
Jeff Dinsmore MIS - Interfaces Ridgeview Medical Center [EMAIL PROTECTED] 952.442.2191 x6592 -----Original Message----- From: Sijmen Mulder [mailto:[EMAIL PROTECTED] Sent: Thursday, February 17, 2005 8:23 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Getting metadata >> PRAGMA table_info(table-name); >> >> http://sqlite.org/pragma.html > > That's just what I was looking for. Thank you very much! It looks very good, but is there also a way to query the currently opened database to get a list of tables?
