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

[Thomas Fjellstrom]

On Saturday 20 January 2007 6:29 am, [EMAIL PROTECTED] wrote:
> 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

exec ".schema tablename" from the C api's sql query function.

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

Its email, select a message and press "reply".

> Thanks in advance.
> Ivailo Karamanolev
>
>
> ---------------------------------------------------------------------------
>-- To unsubscribe, send email to [EMAIL PROTECTED]
> ---------------------------------------------------------------------------
>--

-- 
Thomas Fjellstrom
[EMAIL PROTECTED]

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