PureBasic Forums - English

Posted: **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 ?

Posted: **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

PureBasic Forums - English

Getting a list of tables in SQLite Database

Getting a list of tables in SQLite Database