> Is there another way to get the column schema besides parsing the original > CREATE TABLE command? > > thx > -Brett G. > > ---------------------------------------------------------------- > This message was sent using IMP, the Internet Messaging Program.
Hello Brett You can access the sqlite_master table to get a list of tables. Something like: SELECT name FROM sqlite_master WHERE type='table'; http://www.sqlite.org/cvstrac/wiki?p=InformationSchema For each table then, use PRAGMA table_info(<name>); http://www.sqlite.org/pragma.html#schema There are as well information about indices available. HTH Philipp