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

different breed of cat. Thanks for the tip. Anyway, if anyone out there uses CodeSmith, I uploaded the SQLite schema provider. -- Mario Gutierrez mario.l.gutierrez @ hotmail.com From: Peter Bierman <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: sqlite-users@sqlite.org Subj

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

Thanks for the reply. This would not work as I could define a table like this CRETE TABLE my_table ( id INTEGER PRIMARY KEY, ... ) This would meet your criteria, but 'id' is not an autoincremented column. -- Mario Gutierrez mario.l.gutierrez @ hotmail.com From: "David M

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

Thanks for the reply. Your approach determines if 'my_table' has a column that is autoincremented. I needed a way to determine if a specific column is autoincremented. I resorted to a regular expression match against the SQL to check if a specific column is autoincremented.

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

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/