Getting a list of tables in SQLite Database

Grumble · Post by **Grumble** » Fri Oct 24, 2003 2:56 pm

I started experimenting with SQLite using El Choni's library. It's easy enough to connect to a table of which you know the name, but I can't figure out how to do this for a table that was defined (and given a name) by a user. Anyone knows how can I get a list with the names of the tables inside a given database ?

Pandora · Post by **Pandora** » Fri Oct 24, 2003 3:34 pm

Try to get your information from the sqlite_master table, which should be included in every database.

Code: Select all


SELECT NAME FROM sqlite_master WHERE TYPE='table'

kind regards

Heiko