How to get list of all the tables in sqlite programmatically

Question

How can I get the list of all the available tables in sqlite programmatically?

@MaheshBabu: Jhaliya's answer is correct according to me. So please try that out. — Parth Bhatt, Mar 17 '11 at 05:25
Possible duplicate of [How to list the tables in an SQLite database file that was opened with ATTACH?](http://stackoverflow.com/questions/82875/how-to-list-the-tables-in-an-sqlite-database-file-that-was-opened-with-attach) — KeksArmee, Jan 02 '17 at 04:14

score 34 · Accepted Answer · edited Dec 06 '21 at 08:24

34

try this :

SELECT * FROM sqlite_master where type='table';

edited Dec 06 '21 at 08:24

rofrol

answered Mar 17 '11 at 05:08

Mitesh Khatri

score 8 · Answer 2 · edited May 23 '17 at 12:01

8

Use the below sql statement to get list of all table in sqllite data base

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

The same question asked before on StackOverFlow.

edited May 23 '17 at 12:01

Community

answered Mar 17 '11 at 04:52

1

+1 for your answer because you have even provided the link in case it is not clear. :-) – Parth Bhatt Mar 17 '11 at 05:26

score 1 · Answer 3 · answered Oct 14 '14 at 12:18

1

worked for me

    SELECT * FROM sqlite_master where type='table'

answered Oct 14 '14 at 12:18

M-sAnNan

3 Answers3