Hi Stephan, > Does this help? > > pragma table_info([table-name]) > > The output looks easier to parse than the create-table statement.
Thanks for the link. Yes, I am aware of the pragma table_info command. I use it to generate each column's name and type, but it doesn't give table constraints, column constraints etc. Thanks, Tom BareFeet -- Comparison of SQLite GUI tools: http://www.tandb.com.au/sqlite/compare/?ml _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
