On 2004-11-21, at 14.15, Antonio Coralles wrote:
how can i get the output which will be produced by sqlite>.tables from a
sqlite_exec call inside my programm ?
(i'm using sqlite 2.8.14)

SELECT name FROM sqlite_master WHERE type='table' UNION ALL SELECT name FROM sqlite_temp_master WHERE type='table' ORDER BY name;


Is that what you need? :-)

Tomas Franzén
Lighthead Software
http://www.lightheadsw.com/

Reply via email to