You would use pragma table_info(<table_name>); http://www.sqlite.org/pragma.html#pragma_table_info
--- On Mon, 8/2/10, Chris Hare <[email protected]> wrote: > From: Chris Hare <[email protected]> > Subject: [sqlite] list table structure > To: [email protected] > Date: Monday, August 2, 2010, 12:11 PM > 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 <table>" would be > how I would do it in Oracle. > > Thanks, > Chris > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
