[EMAIL PROTECTED] wrote:
What is the easiest way to retrieve the structure of a table? The only
thing i have found so far is by parsing the `sqlite_master`.`sql`
which seems to be too much coding. I want them as (char**
column_names), (char **column_types) or something similar.
thanks in advance
Ivailo Karamanolev
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
Check out the pragma table_info() command at
http://www.sqlite.org/pragma.html#schema
It gives the requested information for each column in a table.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
