Re: Re: SQLite and Introspection

On 23 Nov 2002, at 13:49, Mike Swieton wrote:

> That SQL bit:
> 
> SELECT name,sql from SQLITE_MASTER WHERE type='table';
> 
> Gives you the the name of the table and the complete SQL used to create it.
> That SQL statement contains all the data about the tables. Everything is
> there.

Yes, everything is there, but it can be essentially impossible to figure 
out.  SQL is hard enough to parse as it is, but if the table is created 
via a SELECT, then you need to infer the column names from the select, 
and so you'd have to parse 'AS's and all manners of things...  For 
*machine* processing, having the SQL of the create-table is pretty close 
to useless, IMO..

  /Bernie\

-- 
Bernie Cosell                     Fantasy Farm Fibers
mailto:bernie-+xAfj8kFFbDnC/t2CciAbw@xxxxxxxxxxxxxxxx     Pearisburg, VA
    -->  Too many people, too few sheep  <--          

To unsubscribe from this group, send an email to:
sqlite-unsubscribe-VgYJa0VH1e9BDgjK7y7TUQ@xxxxxxxxxxxxxxxx

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/