SQLite table list selection

[Mogul1]

Hi, I was wondering if anyone could advise on how could obtain a list of tables held within an SQLite file?

Im hoping to use this list to populate a user interface dropdown via chained app.  Im reluctant to hard code the table list, but may have to go this route if there is no other way to dynamically generate the schema information.

[Mogul1 · Accepted solution]

Hi, OK, Ive found suitable query.

SELECT * FROM sqlite_master

Thanks