Re: Re: SQLite and Introspection

Jim,

I think I didn't made myself clear in my earlier email: even though I 
can access all my tables through SQLITE_MASTER, I cannot access the 
columns for a particular table.

Where are the names of the columns stored for the user tables?

Thanks,

-- Tito

On Saturday, November 23, 2002, at 07:44 AM, jim_lyon_ wrote:

> The permanent tables are kept in SQLITE_MASTER. Temporary ones are
> kept in SQLITE_TEMP_MASTER. These contain all tables, views, and
> indexes. Triggers are only available from the internal C fns.
>
> To inspect all tables:
> SELECT name,sql from SQLITE_MASTER WHERE type='table';
>
> Jim Lyon


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/