On 20 Jan 2010, at 2:13pm, BareFeet wrote: > This question seems to come up every now and then, but I've yet to see any > solution. The best phrasing of the question I found was back in 2004: > http://www.mail-archive.com/sqlite-users@sqlite.org/msg02649.html > > Is there any way to parse a create statement (eg create table, create view, > create trigger) into its components? > > Since SQLite does this internally using the Lemon parser, surely there's a > simple way to get the parser results?
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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
