Try this: select * from sqlite_master;
On 8/8/05, Will Leshner <[EMAIL PROTECTED]> wrote: > > On Aug 8, 2005, at 5:14 AM, Matthew Gertner wrote: > > > I'm wondering if there is a way to get information about the format > > of tables in > > an existing Sqlite database. Specifically, I would like to get the > > list of > > columns and the data type of each column. > > Check out the table_info PRAGMA on this page: > > <http://sqlite.org/pragma.html> > --- The Castles of Dereth Calendar: a tour of the art and architecture of Asheron's Call http://www.lulu.com/content/77264