I'm trying to do the exact same thing via a C++ app right now. I don't know if a "schema" can be create other way than via the command line .s . But it may help you to know that there's a table called sqlite_master that contain infos on each tables and indexes of your database.
I'm currently iterating through it to get what I call "MyDB_Structure". I can then validate each table/column of a DB. I can output the info of combine sqlite_master + PRAGMA table_info (tableName) in an XML file when I know my MyDB_Structure is ok and whenever I need to validate table/column of the DB, I load the XML file and try to match Structure with sqlite_master + PRAGMA table_info (tableName). Hope that gives you a hint. :) Antoine Caron -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karl Lautman Sent: October 23, 2008 4:18 PM To: sqlite-users@sqlite.org Subject: [sqlite] How to generate a scheme I'm still feeling my way around sqlite. One thing that would be handy would be the ability to generate a scheme (schema?) for a particular database, to confirm it has the tables I think it has, and those tables have the characteristics I think they have (as well as to refresh my memory). How is this done with sqlite? I'm partial to python, so if there's a python module to do it, so much the better. Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users