Re: [sqlite] Schemas
On 9/28/05, Vivien Malerba <[EMAIL PROTECTED]> wrote:
> 2005/9/28, Firman Wandayandi <[EMAIL PROTECTED]>:
> > On 9/27/05, Vivien Malerba <[EMAIL PROTECTED]> wrote:
> > > Hi!
> > >
> > > I'm working on the SQLite interface between the Libgda library and the
> > > SQLite database. For the job, I need to know information about the
> > > database schema, and I'm using the PRAGMA statements regarding
> > > schemas.
> > >
> > > However I can't find the information about the AUTO INCREMENT
> > > attribute of a column. Can anyone help me?
> > >
> >
> > here they are,
> >
> > http://sqlite.org/datatypes.html
> > http://sqlite.org/datatype3.html
> >
>
> I don't mean finding information about how to create AUTO INCREMENT
> fields but about how to get that information for each field of an
> already existing table in the database (like when using PRAGMA
> table_info('table')).
>
Oh, sorry, you can use
SELECT * FROM sqlite_master
and find yourself where the auto increment column form "sql" column
with "AUTOINCREMENT" as the wild card, I dunno another solution.
> Thanks,
>
> Vivien
>
Hope help you,
--
Firman Wandayandi
Never Dreamt Before (http://php.hm/~firman/)
Re: [sqlite] Schemas
2005/9/28, Firman Wandayandi <[EMAIL PROTECTED]>:
> On 9/27/05, Vivien Malerba <[EMAIL PROTECTED]> wrote:
> > Hi!
> >
> > I'm working on the SQLite interface between the Libgda library and the
> > SQLite database. For the job, I need to know information about the
> > database schema, and I'm using the PRAGMA statements regarding
> > schemas.
> >
> > However I can't find the information about the AUTO INCREMENT
> > attribute of a column. Can anyone help me?
> >
>
> here they are,
>
> http://sqlite.org/datatypes.html
> http://sqlite.org/datatype3.html
>
I don't mean finding information about how to create AUTO INCREMENT
fields but about how to get that information for each field of an
already existing table in the database (like when using PRAGMA
table_info('table')).
Thanks,
Vivien
Re: [sqlite] Schemas
On 9/27/05, Vivien Malerba <[EMAIL PROTECTED]> wrote: > Hi! > > I'm working on the SQLite interface between the Libgda library and the > SQLite database. For the job, I need to know information about the > database schema, and I'm using the PRAGMA statements regarding > schemas. > > However I can't find the information about the AUTO INCREMENT > attribute of a column. Can anyone help me? > here they are, http://sqlite.org/datatypes.html http://sqlite.org/datatype3.html > Thanks a lot, > > Vivien > -- Firman Wandayandi Never Dreamt Before (http://php.hm/~firman/)
[sqlite] Schemas
Hi! I'm working on the SQLite interface between the Libgda library and the SQLite database. For the job, I need to know information about the database schema, and I'm using the PRAGMA statements regarding schemas. However I can't find the information about the AUTO INCREMENT attribute of a column. Can anyone help me? Thanks a lot, Vivien
