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
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
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.
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
4 matches
Mail list logo