-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > 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,
That is something you have to do by hand. The formal process for doing so is known as normalization http://en.wikipedia.org/wiki/Database_normalization Only you know how the various things you want to store information about are related, if they have one to one, many to one, many to many etc relationships and so on. > confirm it has the tables I think it has, To get the list of tables: select tbl_name from sqlite_master where type='table'; To get information about a particular table: pragma table_info(tablename); > I'm partial to python, so if there's a python module > to do it, so much the better. Those queries will work with any interface to SQLite that can issue queries and give you a response. If you use the command line sqlite3 shell then remember to do '.headers on' to get a header row of output. For Python you can use pysqlite or APSW to access SQLite. (Disclaimer: I am the author of APSW). Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkkCSbAACgkQmOOfHg372QRWuwCgz5GpNgxnjtWnG464gCYx3ogp ENYAoMObAhltJsKMr9t+Ub/WGCyAf6ZK =MYMi -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
