thanks ! that was exactly what I was searching !
Dennis Cote wrote: > > > You can get the names of tables and indexes by querying the > sqlite_master table. > > select * from sqlite_master where type = 'table'; > > You can get detailed information about the columns in a table using the > pragma table_info. Details are at http://www.sqlite.org/pragma.html > > pragma table_info('some_table'); > > both of these queries can be executed using the C API just like any > other query. > > HTH > Dennis Cote > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/Accessing-to-database-informations-tp18098876p18100654.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
