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 program? Foro
> > example "describe <table>" would be how I would do it in Oracle.
>
> http://www.sqlite.org/faq.html#q7
Oops, too fast. I meant to add...
Once you have the table name, you can look-up specifics via:
PRAGMA <database>.table_info( <table_name> )
http://sqlite.org/pragma.html#pragma_table_info
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Intelligence is like underwear: it is important that you have it,
but showing it to the wrong people has the tendency to make them
feel uncomfortable." -- Angela Johnson
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
