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

Reply via email to