On Jun 16, 2008, at 4:42 AM, Csaba wrote:
> Hi, I didn't get a response to my first post to this group
> and I didn't get a copy, so perhaps it didn't go through...
>
> Is there any way to detect, based strictly on querying
> the structure of a table/database whether there is an
> AUTOINCREMENT set? That is to say, without
> analyzing the original SQL creation statement, and
> without inserting a new element into the database.
>
> How is the difference between these two detectable?
> CREATE Table myTab ('AUTOINCREMENT col' INTEGER AUTOINCREMENT
> PRIMARY KEY)
> vs.
> CREATE Table myTab ('AUTOINCREMENT col' INTEGER PRIMARY KEY)
>
http://www.sqlite.org/c3ref/table_column_metadata.html
D. Richard Hipp
[EMAIL PROTECTED]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
