Re: SQLite and Introspection

--- In sqlite-F5Bj5G+ccuY@xxxxxxxxxxxxxxxx, Tito Ciuro <tciuro@xxxx> wrote:
> 
> Thanks for the info. I can now get the list of the tables :)
> 
> However, I haven't been able to find the name of the table that 
> contains the schema. What SQLite internal table contains the schema?

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/