[sqlite] How to determine if a column is autoincremented?

[Mario Gutierrez]

Hi all,

I'm writing a SQLite adapter for a code generation tool. I'm a little 
stumped on how you query SQLite to determine if a column is autoincremented. 
I've tried

        PRAGMA table_info('my_table');

which returns all the columns for the table including a flag to tell if the 
column is a primary key member. However, there is not a flag to indicate 
whether a column is autoincremented. I then tried

        SELECT * FROM sqlite_sequence;

which doesn't return anything if the table is newly created. I'm not 
interfacing with the DLL directly, so I hope it can be done with a query.

--
Mario Gutierrez
mario.l.gutierrez @ hotmail.com

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/