Re: [sqlite] How to get the schema

[Boris Popov]

Brett Goodman wrote:
Is there another way to get the column schema besides parsing the original
CREATE TABLE command?

Sure, sqlite3_table_column_metadata, see

http://sqlite.org/capi3ref.html#sqlite3_table_column_metadata

This routine is used to obtain meta information about a specific column 
of a specific database table accessible using the connection handle 
passed as the first function argument.

Cheers!

--
-Boris
http://bpopov.wordpress.com