From within a C/C++ program (or a script using Tcl/Ruby/Perl/Python bindings) you can get access to table and index names by doing a SELECT on a special table named "sqlITE_MASTER ". Every sqlite database has an sqlITE_MASTER table that defines the schema for the database.

sql code

   
   

    
    
    
    SELECT  name  FROM  sqlite_master
  WHERE  type = ' table ' 
  ORDER   BY  name;