Re: [sqlite] SQLite Introspection

2010-12-07 Thread BareFeetWare
On 07/12/2010, at 11:25 AM, Tom Krehbiel wrote: > I haven't been able to find anything in the documentation that indicates how > to get at the trigger definition. You can, of course, get the definition of any entity from the SQLite_Master table, such as: select Name, SQL from SQLite_Master whe

Re: [sqlite] SQLite Introspection

2010-12-07 Thread Jay A. Kreibich
On Mon, Dec 06, 2010 at 05:25:43PM -0700, Tom Krehbiel scratched on the wall: > The documentation for the analyze > command says they can do a *select *on table *sqlite_stat1 *but when I do a > select I get an error with 'no such table: sqlite_stat1'. Like the table sqlite_sequence (used for AU