Re: Re: SQLite and Introspection

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.

On Sat, Nov 23, 2002 at 02:19:43PM +0100, Tito Ciuro wrote:
> Where are the names of the columns stored for the user tables?
> 
> On Saturday, November 23, 2002, at 07:44 AM, jim_lyon_ wrote:
> > To inspect all tables:
> > SELECT name,sql from SQLITE_MASTER WHERE type='table';

Mike Swieton
--
There is a natural order. The way things are meant to be. An order that says
the good guys always win. That you die when its your time, or you have it
coming. That the ending is always happy, if only for someone else.
        - Christopher McQuarrie, The Way Of The Gun

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/