How to list the table name from sqlite DB -- Android [duplicate]

Question

I am new to android sqlite. i want to get list of table residing in one particular database. Is this possible in sqlite. Can anyone guide me on this. I searched long time for this, dint get any idea.

For example : My dB name is ABC, in that i have 10 different tables, i want to get the list of table names from that particular Db. Thanks in advance

Pull the DB from the device through file explorer. Install SQLite manager as plugin to the browser (Firefox). Then open your DB through SQLite manager. — Rahul Patil
– Rahul Patil, Commented Jun 19, 2013 at 7:41

AllTooSir · Accepted Answer · 2013-06-19 07:29:15Z

1

You need to query the sqlite_master table of the schema ABC .

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

answered Jun 19, 2013 at 7:29

AllTooSir

49.5k17 gold badges132 silver badges164 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to list the table name from sqlite DB -- Android [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related