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