How to get list of all tables in sqlite programmatically

Question

How to programmatically list all available tables in sqlite?

Answer 1

try the following:

SELECT * FROM sqlite_master where type='table'

Answer 2

Use the sql statement below to list the entire table in sqlite database

SELECT * FROM dbname.sqlite_master WHERE type='table';

The same question was asked earlier in StackOverFlow.

How to list tables in a SQLite database file that was opened using ATTACH?

Answer 3

worked for me

    SELECT * FROM sqlite_master where type='table'