[sqlite] 1. Table Schema; 2. Using this list

[ivailo91]

Mark Richards wrote:
> [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
> >
> >
> .schema {tablename}
>
> sqlite3
> .help

1. Isn't that supposed to return the SQL syntax for the table
creation?
1.1. I would like to do this from the C API


2. How am i supposed to write replies to someone's post in this mailing
list?

Thanks in advance.
Ivailo Karamanolev


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------