c.panel wrote: > > I'm a new user of SQLite, (and SQL too). I'm trying to find how can I access > to tables names, column names and types, from a database, using C API. I > found this from a result set but what about resident tables ?. Perhaps must > I use a SELECT statement for this ? But If I do, does SQLLite generate a > file from database (so time consuming...) or Is there a method I missed ? >
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
