The documentation for sqlite3_table_column_metadata C function can be
found here; https://www.sqlite.org/c3ref/table_column_metadata.html.
You just call it in turn on each column in a table (you can get the
column names for a table by using Pragma table_info) and check the value
of the 9th argument.
Peter
On 4/13/2016 7:58 PM, Igor Korot wrote:
> Hi,
>
> On Wed, Apr 13, 2016 at 1:54 PM, Igor Korot <ikorot01 at gmail.com> wrote:
>> Hi, Peter,
>>
>> On Wed, Apr 13, 2016 at 1:16 PM, Peter Aronson <pbaronson at att.net> wrote:
>>> There is one limitation to this approach, however. The entry for an
>>> autoincrement column in the sqlite_sequence table isn't made until the
>>> first row is inserted into the table. If you are also using the C
>>> interface, you can identify autoincrement columns using
>>> sqlite3_table_column_metadata.
>> I will test that when I come home from work.
> Yes, that didn't work.
>
> Can you tell me how to use sqlite3_table_column_metadata?
>
> Thank you.
>
>> Thank you.
>>
>>> Peter
>>>
>>> On Wednesday, April 13, 2016 9:40 AM, Igor Korot <ikorot01 at
>>> gmail.com> wrote:
>>>
>>>
>>>
>>> Hi, Kees,
>>>
>>> On Wed, Apr 13, 2016 at 12:15 PM, Kees Nuyt <k.nuyt at zonnet.nl> wrote:
>>>> On Wed, 13 Apr 2016 10:58:54 -0400, Igor Korot
>>>> <ikorot01 at gmail.com> wrote:
>>>>
>>>>> Hi,,
>>>>>
>>>>> On Wed, Apr 13, 2016 at 10:54 AM, J Decker <d3ck0r at gmail.com> wrote:
>>>>>> Yes, you can get the create statement from sqlite_master table
>>>>> I was kind of hoping for a simpler solution so that not to
>>>>> parse "CREATE TABLE" statement...
>>>>>
>>>>> Well, I guess I will have to.
>>>> With AUTOINCREMENT, the last autoincremented primary key value
>>>> is tracked in a table called sqlite_sequence.
>>>>
>>>> $ sqlite3 test2.db
>>>> SQLite version 3.8.12 2015-10-07 00:35:18
>>>> Enter ".help" for usage hints.
>>>> sqlite> create table t1 (id INTEGER PRIMARY KEY, tx TEXT);
>>>> sqlite> create table t2 (id INTEGER PRIMARY KEY AUTOINCREMENT,
>>>> tx TEXT);
>>>> sqlite> INSERT INTO t1 (tx) VALUES ('one'),('two');
>>>> sqlite> INSERT INTO t2 (tx) VALUES ('one'),('two');
>>>> sqlite> SELECT name FROM sqlite_master WHERE type='table';
>>>> t1
>>>> t2
>>>> sqlite_sequence
>>>> sqlite> SELECT * FROM sqlite_sequence;
>>>> t2|2
>>>> sqlite>
>>> So I can actually query sqlite_sequence table with the table name in WHERE
>>> clause and it should give me the field that is set to be autoincrement.
>>>
>>> For the reference: https://www.sqlite.org/fileformat2.html (paragraph
>>> 2.6.2).
>>>
>>> Thank you.
>>>
>>> P.S.: There is a small typo on the page/paragraph I referenced:
>>>
>>> [quote]
>>> The schema for the sqlite_sequence table is:
>>>
>>> CREATE TABLE sqlite_sequence(name,seq);
>>>
>>> There is a single row in the sqlite_sequence table for each ordinary
>>> table that uses AUTOINCREMENT. The name of the table (as it appears in
>>> sqlite_master.name) is in the sqlite_sequence.main field and the
>>> largest INTEGER PRIMARY KEY ever used by that table is in the
>>> sqlite_sequence.seq field.
>>> [/quote]
>>>
>>> That should be changed to:
>>>
>>> [changes}
>>> The name of the table (as it appears in sqlite_master.name) is in the
>>> sqlite_sequence._name_ field
>>> [/changes]
>>>
>>> Could someone please correct that? The changes are between the underscores.
>>>
>>> Thank you.
>>>
>>>> Hope this helps
>>>>
>>>>
>>>>>> On Wed, Apr 13, 2016 at 4:54 AM, Igor Korot <ikorot01 at gmail.com>
>>>>>> wrote:
>>>>>>> Hi,
>>>>>>> Is it possible to get whether the column is set to autoincrement or not?
>>>>>>>
>>>>>>> PRAGMA table_info() does not give such info...
>>>>>>>
>>>>>>> Thank you.
>>>> --
>>>> Regards,
>>>> Kees Nuyt
>>>> _______________________________________________
>>>> sqlite-users mailing list
>>>> sqlite-users at mailinglists.sqlite.org
>>>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>> _______________________________________________
>>> sqlite-users mailing list
>>> sqlite-users at mailinglists.sqlite.org
>>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> sqlite-users mailing list
>>> sqlite-users at mailinglists.sqlite.org
>>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
