Re: [sqlite] Extracting database schema information

[Matthew Gertner]

Thanks, Will, that's exactly what I was looking for.

Will Leshner 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>