Re: [sqlite] list table structure

2010-08-02 Thread Jay A. Kreibich
On Mon, Aug 02, 2010 at 11:21:12AM -0500, Jay A. Kreibich scratched on the wall: > On Mon, Aug 02, 2010 at 11:11:25AM -0500, Chris Hare scratched on the wall: > > I read on the SQLite how to get the list of tables in the SQLite database. > > > > How do I get the table structure from within a

Re: [sqlite] list table structure

2010-08-02 Thread David Bicking
You would use pragma table_info(); http://www.sqlite.org/pragma.html#pragma_table_info --- On Mon, 8/2/10, Chris Hare <ch...@labr.net> wrote: > From: Chris Hare <ch...@labr.net> > Subject: [sqlite] list table structure > To: sqlite-users@sqlite.org > Date: Monday, Augu

Re: [sqlite] list table structure

2010-08-02 Thread Jay A. Kreibich
On Mon, Aug 02, 2010 at 11:11:25AM -0500, Chris Hare scratched on the wall: > I read on the SQLite how to get the list of tables in the SQLite database. > > How do I get the table structure from within a program? Foro > example "describe " would be how I would do it in Oracle.

[sqlite] list table structure

2010-08-02 Thread Chris Hare
I read on the SQLite how to get the list of tables in the SQLite database. How do I get the table structure from within a program? For example "describe " would be how I would do it in Oracle. Thanks, Chris ___ sqlite-users mailing list