Geek Answers Handbook

Get a list of all tables in the database

I have this database file in a folder with regular databases and a bunch of tables inside it.

Please note that I do not want to extract data from the command line. I know that I can use the ".tables" command.

I want to get a list of all the tables in it using code so that I can execute some specific algorithms for each of them.

In addition, I did not find any issues with this problem on Android, so please forgive me if there are any. I was wondering if there is any function that I can use in DatabaseUtils, but I also did not find it.

+5
source share
1

select name from sqlite_master where type = 'table'
+14

More articles:


All Articles