SELECT name FROM sqlite_master WHERE type = 'table'
Best regards, Witold Czarnecki
----- Original Message ----- From: "Sijmen Mulder" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, February 17, 2005 3:22 PM
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?
