Hi Simon, >> Is there any way to parse a create statement (eg create table, create view, >> create trigger) into its components?
> Have you seen > > <http://www.sqlite.org/lang_explain.html> > > ? You can do this with many kinds of statements, not just SELECT. It > doesn't do just what you want, but its output could be useful for whatever > you want it for. Thanks for the link but, no, it doesn't seem to provide anything I could, for example, use to parse a create table statement into an array of column definitions, each showing name, type, array of constraints (as illustrated in previous email). 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